I've a silly problem with a form, which I can't seem to get to the root of.
The form has a field, RowID - it's a GUID, the key of the underlying SQL Server table. Before opening the form in 'new' mode, I set a variable to GUID() and the default of value of the RowID card tests the form mode and picks up that variable value. I can see the GUID in the field on the form when it opens.
When I SubmitForm() the form, the app tells me that 'RowID is required'. The field is populated; I can see the value!
Why does it think the field isn't populated?
I've also tried Set(ThisItem.RowID) before SubmitForm() in the save action, but that just gives code check errors.
Thanks!
The 'New' button that opens the form has this code:
ResetForm(Form_PartnerEdit);
Set(NewRowID,GUID());
NewForm(Form_PartnerEdit);
Navigate(Screen_PartnerEdit);
and the 'RowID' card's default is this:
If(Form_PartnerEdit.Mode=FormMode.New, NewRowID,ThisItem.RowID)