
Hi Everyone,
I have two hidden fields in a form, whose values i want to change upon SubmitForm with a button press;
One is a date field which i want to update to Now()
The other is a binary choice - I have selected a default value but this isn't populating automatically. I would like to specify this value as it is a required field.
Also, I would like to update the date field to Now() on a button press when the entry has been selected on a table.
How would I go about updating these as/before the form submission?
Sorry for the newbie questions!
Hi , @BATOU
First you need to all your need field in your Form control.
Then for your Date field to set to now() , you can use this expression in your DatePicker's Datacard - Update property:
And then you can set this DataCard - Visible to false to hide this DataCard.
For your Choice column , you can set the Combo box control - DefaultSelectColumns , For example:
And you can also set this DataCard - Visible to false to hide this DataCard.
Then you can use the SubmitForm(Form1) function to submit the Form data to your SharePoint list , the result is as follows:
If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!
Best Regards,
Yueyun Zhang