Home › Forum › Working with Tables › Update table values using a form connection
This topic contains 1 reply, has 0 voices, and was last updated by MABrown 11 years, 4 months ago.
- AuthorPosts
- October 23, 2009 at 8:38 pm #337
I have a form with a table. I want to create another form that will pull back all of the rows from the tables of multiple form instances, allow the user to update those values, and then commit those changes to the individual form instances.
Is it possible to update individual values in the rows of a table using a form connection?
October 27, 2009 at 12:57 pm #4872This is possible but a little complicated.
Use a Form Connection to import all the rows from multiple form instances and make sure that you also import the forms instance ID’s so you know where each row came from.
In your ‘master’ form you will have all instances in a single table; the data can be modified (except for the instance ID would is better if it is hidden).
The complication arises because you cannot pass all the data back in a single action otherwise everything will go back to a single form instance.
You will need to build a ‘looping’ behavior which does the following:
1) Using the instance ID, copy all the rows from a single instance into another table object on the same form (can be hidden)
2) Use a Form Update Connection to send all this data back to the instance it came from
3) Delete the data in the hidden table
4) Using the instance ID, copy all the rows from the next instance into the hidden table
5) Send all this data back to the instance it came from
And so on until all the data has been returned.
Note: The data that you send back to the original form instance will overwrite the data that was already there, so if you send 5 rows of data to the master form, then delete a row in the master form and send it back, then you will only get 4 rows showing in the original form instance.
Note also: There is a known issue which means no data will be returned from the master form if there is only a single row sent via the Forms Update Connection.
- AuthorPosts
You must be logged in to reply to this topic.