I have datasource from excel serveral tables.
and I datasource of from as dynamic table link to dropdown.
but when I save data by SubmitForm(Form1). It's not working.
Solved! Go to Solution.
Oops! sorry it's working fine
able to submit form now.
After I changed to assigned table with Set(tb,switch(...))
Previously I have assigned table by store multi tables in Collection.
Hi @akario
Is the Edit Form mapped on a single table for insert/update or how is it.
If its Edit Form, can you check the DataField & Update Properties of the DataCard.
Thanks.
Hi @akario ,
Please check:
1)whether the excel file was opening when you submitted the form?
2)did you set the right property to the dropdown? (DropDown1.Selected.fieldname)
Do you have any error message?
Could you show your screenshoots or the settings of the form?
Best regards,
Community Support Team _ Phoebe Liu
Show error message below
"There was a problem saving your changes. The data source may be invalid"
Due to I assigned table with below fx
Set(TBSc,Switch( LabelTable.Text,"Sb01",Tb01,"Sb02",Tb02,...)
and then I have set Data Source of EditForm1 as TBSc
once I run SubmitForm(EditForm1)
the message above occure
Oops! sorry it's working fine
able to submit form now.
After I changed to assigned table with Set(tb,switch(...))
Previously I have assigned table by store multi tables in Collection.
User | Count |
---|---|
177 | |
118 | |
88 | |
44 | |
41 |
User | Count |
---|---|
241 | |
153 | |
127 | |
77 | |
72 |