How would i make a template column dependent column update automatically

how would I make a template-dependent column update automatically? I have 2 different sheets that I made to relate through the template column, the template column updates itself fine, but it does that only when the other column is updated manually.

I want to know how to do this so that, that dependent column can be updated from the front end or automatically in accordance with increase in rows from the other sheet? @Jeff_Hager


I want the serial column(in the 1st picture) to update automatically as the email column of the other sheet increase (the 2nd picture).

I’m not sure I follow since there isn’t much to see in the screenshots. What is your ultimate goal? Can you expand on your explanation a little more.? Are you just trying to get the serial column to increment whenever the second sheet has a new record?

Yes I’m trying to this:

“Are you just trying to get the serial column to increment whenever the second sheet has a new record?”

Though, i found a way to do that from the frontend of the admin version but I’m open to more suggestions.

Thanks.

My best idea involve a form button. First on the detail screen for the sheet that contains the form button, you first add a rollup component to get the count. Then you add a math column that takes the rollup value and adds 1. Then you can pass the match column value into the form button and when it writes a new record, it will write the new serial number. This will cause the rollup and math columns to increment by 1 and be ready for the next form submission.

1 Like