# How would i make a template column dependent column update automatically
**URL:** https://community.glideapps.com/t/how-would-i-make-a-template-column-dependent-column-update-automatically/8269
**Category:** Ask for Help
**Created:** [May 1, 2020, 8:35am UTC](https://community.glideapps.com/t/how-would-i-make-a-template-column-dependent-column-update-automatically/8269 "2020-05-01T08:35:30Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@Suleimaan](https://community.glideapps.com/u/Suleimaan)
#### Post date: [May 1, 2020, 8:35am UTC](https://community.glideapps.com/t/how-would-i-make-a-template-column-dependent-column-update-automatically/8269/1 "2020-05-01T08:35:30Z")
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).
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [May 2, 2020, 2:21pm UTC](https://community.glideapps.com/t/how-would-i-make-a-template-column-dependent-column-update-automatically/8269/2 "2020-05-02T14:21:17Z")
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?
---
### Author:  [@Suleimaan](https://community.glideapps.com/u/Suleimaan)
#### Post date: [May 2, 2020, 5:23pm UTC](https://community.glideapps.com/t/how-would-i-make-a-template-column-dependent-column-update-automatically/8269/3 "2020-05-02T17:23:57Z")
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.
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [May 2, 2020, 7:58pm UTC](https://community.glideapps.com/t/how-would-i-make-a-template-column-dependent-column-update-automatically/8269/4 "2020-05-02T19:58:30Z")
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.
---
### Author:  [@gp9293](https://community.glideapps.com/u/gp9293)
#### Post date: [October 5, 2021, 2:44pm UTC](https://community.glideapps.com/t/how-would-i-make-a-template-column-dependent-column-update-automatically/8269/5 "2021-10-05T14:44:23Z")
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
---
### Author:  [@gp9293](https://community.glideapps.com/u/gp9293)
#### Post date: [October 5, 2021, 2:46pm UTC](https://community.glideapps.com/t/how-would-i-make-a-template-column-dependent-column-update-automatically/8269/6 "2021-10-05T14:46:22Z")
Jeff: I reread your post a few more times and cracked this. Thank you.