Adding the option to add information to two data form

Ask for Help
1

I currently have an ‘Add Item’ form for adding information to Data File 3. I would also like to add the option for my user to add the same information to Data file 2. I have tried everything AI Chat has asked, but nothing worked. I am new to Glide, so any help, especially detailed help, would be much appreciated. I would like to say thank you in advance for your help and support.

2

So is the information going to Data File 2 the exact same as Data File 3? Can you explain more why does it need to be stored in 2 places if it’s the same data?

3

Thank you for responding ThinhDinh. I don’t want all the information from the form to go to Data 2; I just want key points if the user requests it. The information stored in Data 3 can also be useful in Data 2, but not always. The columns I want to add the Data 2 from Data 3 will be the same, but the Data has different functions. I hope this helps explain it a little better.

4

I think your most straightforward option is to add an “Also add to Data 2” boolean in your form.

If it’s true, add an on-submit action to write data from Data 3 to Data 2.

However, I also want to dive a bit into why this isn’t ideal. Duplicating the same fields into two tables on submit creates silent inconsistency over time. If a value changes in Data 3 but the copy in Data 2 isn’t updated, the two diverge, UI logic becomes brittle, and maintenance multiplies.

I think your approach can treat Data 3 as canonical. Store a RowID (or key) from Data 3 inside Data 2 when the user opts in, not the duplicated values. Use Relation + Lookup/Rollup columns in Data 2 to surface the “key points” from Data 3.