How to take form inputs (1 table - screen) and Set Column Values in different Tables (multiple tables)

Ask for Help
1

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

2

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”?

3

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

4

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.

5

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.