How would i make a template column dependent column update automatically

Ask for Help
1

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

save4glideco1
save4glideco1370×520 4.75 KB

save4glideco3
save4glideco3120×507 2.31 KB

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

2

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?

3

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.

4

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.

3 Likes
5

Jeff: i have been trying to implement this, but get stuck at the following:

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

I have the max and the math columns working, but is the next step to create an action upon form submit? If so, can you give me some breadcrumbs?

Thank you

6

Jeff: I reread your post a few more times and cracked this. Thank you.

1 Like