Forum Discussion
I tried to edit my post to finish explaining but it errored out and didn't save. So my thought is that if the user in App A completes her form and posts to her table and the set criteria initiates an automation that sends that information to App B and populates the table will the table treat her entries the same way it does for information submitted via its actual form? In the actual form the options are built in through table to table relationships and there are selection dependent dropdowns. As long as her entries are identical to the options on the form will it adopt them in the same format?
Just a thought to the design of your app.
It is typically better to not be duplicating records in other tables and then especially if you then need to duplicate updates from one table to another. They will inevitably get out of Sync which will make you crazy.
Have you considered perhaps a Sync table for the other table - so it will always be a mirror of the main table. Then you just have one source of truth.
It is typically better to not be duplicating records in other tables and then especially if you then need to duplicate updates from one table to another. They will inevitably get out of Sync which will make you crazy.
Have you considered perhaps a Sync table for the other table - so it will always be a mirror of the main table. Then you just have one source of truth.