# How to take form inputs (1 table - screen) and Set Column Values in different Tables (multiple tables)
**URL:** https://community.glideapps.com/t/how-to-take-form-inputs-1-table-screen-and-set-column-values-in-different-tables-multiple-tables/78369
**Category:** Ask for Help
**Created:** [December 4, 2024, 8:09pm UTC](https://community.glideapps.com/t/how-to-take-form-inputs-1-table-screen-and-set-column-values-in-different-tables-multiple-tables/78369 "2024-12-04T20:09:16Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@Brian\_Mac](https://community.glideapps.com/u/Brian_Mac)
#### Post date: [December 4, 2024, 8:09pm UTC](https://community.glideapps.com/t/how-to-take-form-inputs-1-table-screen-and-set-column-values-in-different-tables-multiple-tables/78369/1 "2024-12-04T20:09:16Z")
Hi - tried to find a solution but not fully understanding how to do Trebuchet for this or if there is not another way around it.
I would think a form could capture multiple inputs that would have to go to multiple locations ie. specific rows on different tables. Like it seems like a basic functionality to be able to write data to multiple locations…
For example:
I have a number input that asks - What is your existing revenue? – this needs to set the amount column on a specific row on the Revenue Existing Table
Then a second number input that asks - What is your current revenue? that needs to set a amount column on Revenue This Year Table
The form has its own specific Table called Wizard
On this Wizard table I can do:
1. Query to find the right row - limit 1
2. Lookup the Query to retrieve the row ID
3. Relate the Row using the Lookup Row ID
4. Then lookup the Relation field to return the column value
\*This allows me to put the existing value if any as a placeholder
However I can’t Set Column Values to the Related Row - Related Revenue Existing Table Amount field (single relation no match turned on)
Thanks in advance
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [December 5, 2024, 12:25am UTC](https://community.glideapps.com/t/how-to-take-form-inputs-1-table-screen-and-set-column-values-in-different-tables-multiple-tables/78369/2 "2024-12-05T00:25:32Z")
That sounds like a weird way to structure a form. Wouldn’t it be easier if you just submit all those types of info in a centralized table?
What’s your use case for “Revenue Existing” and “Revenue This Year”?
---
### Author:  [@Brian\_Mac](https://community.glideapps.com/u/Brian_Mac)
#### Post date: [December 5, 2024, 10:37am UTC](https://community.glideapps.com/t/how-to-take-form-inputs-1-table-screen-and-set-column-values-in-different-tables-multiple-tables/78369/3 "2024-12-05T10:37:48Z")
I am building a financial model - using the form as an input wizard hence some of the data points are not all in one centralised table. Nature of relationships and various calculations
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [December 6, 2024, 12:30am UTC](https://community.glideapps.com/t/how-to-take-form-inputs-1-table-screen-and-set-column-values-in-different-tables-multiple-tables/78369/4 "2024-12-06T00:30:23Z")
When you say financial model, are you calculating stuff in Sheets/Excel, or you’re still doing it in Glide Tables?
Trying to understand the data structure so we can offer more suggestions.
---
### Author:  [@Brian\_Mac](https://community.glideapps.com/u/Brian_Mac)
#### Post date: [December 6, 2024, 10:06am UTC](https://community.glideapps.com/t/how-to-take-form-inputs-1-table-screen-and-set-column-values-in-different-tables-multiple-tables/78369/5 "2024-12-06T10:06:49Z")
I have remade the data tables - structures in Glide tables
My work around now is to do a custom collection that shows the specific input field that needs to be filled out using filters, and then just styled as a form input component.
Annoying as depends on the amount of data tables that need to be updated I need that many containers vs a single form that can set columns across multiple data sources.