Is it possible to:
1 make a collection from an edit form and
2 save the collection as a new record in a table (Excel) which is separate from the form's datasource?
Thanks in advance
Solved! Go to Solution.
Thanks for your reply.
I have a form pulling data from a gallery (Gallery1.Selected). The datasource of the gallery is an Excel Table1.
The form has 5 datacards from the Gallery with text inputs.
I am trying to make a collection from the 5 datacard inputs so that I can save them to a new Excel Table2 as separate rows, (instead of submitting the form to the original datasource).
I hope this makes sense!!
I'm sorry your solution doesn't work for me. The form datasource is not the same as gallery1. I'm trying to collect and patch the form data to a new datasource (not the gallery1 datasource).