# Update Sheet A when Submit Form B **URL:** \ **Category:** Ask for Help\ **Created:** [July 7, 2020, 8:10am UTC](https://community.glideapps.com/t/update-sheet-a-when-submit-form-b/12090 "2020-07-07T08:10:21Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![trisixnine](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/trisixnine/32/10044_2.png) [@trisixnine](https://community.glideapps.com/u/trisixnine)\ **Post date:** [July 7, 2020, 8:10am UTC](https://community.glideapps.com/t/update-sheet-a-when-submit-form-b/12090/1 "2020-07-07T08:10:21Z")
Hi there, before to get crazy by myself, Im asking help in the following: at the time of write a new Form, to add a new record in the Sheet B I need also to update a value (date) in the Sheet A Perhaps A.UpDate = B.NewDate I know its should be easy, but i didntfind the proper why, maybe with the realtion, but I dont know out to update the related table. Any easy suggestions? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [July 7, 2020, 8:22am UTC](https://community.glideapps.com/t/update-sheet-a-when-submit-form-b/12090/2 "2020-07-07T08:22:11Z")
So is it something like A shows the latest update time from B? ---
**Author:** ![trisixnine](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/trisixnine/32/10044_2.png) [@trisixnine](https://community.glideapps.com/u/trisixnine)\ **Post date:** [July 7, 2020, 8:43am UTC](https://community.glideapps.com/t/update-sheet-a-when-submit-form-b/12090/3 "2020-07-07T08:43:04Z")
Yes, when there is a new insert of data in B then update a certain field on table A ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [July 7, 2020, 8:46am UTC](https://community.glideapps.com/t/update-sheet-a-when-submit-form-b/12090/4 "2020-07-07T08:46:14Z")
Is it specifically a date or a text/number column? I was thinking if you want the latest date in sheet A then you can do a relation - rollup with sheet B. ---
**Author:** ![trisixnine](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/trisixnine/32/10044_2.png) [@trisixnine](https://community.glideapps.com/u/trisixnine)\ **Post date:** [July 7, 2020, 8:48am UTC](https://community.glideapps.com/t/update-sheet-a-when-submit-form-b/12090/5 "2020-07-07T08:48:39Z")
yes it is a date, but I can arrange it also with a simple flag eventually. but best is to have the latest up date ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [July 7, 2020, 8:51am UTC](https://community.glideapps.com/t/update-sheet-a-when-submit-form-b/12090/6 "2020-07-07T08:51:25Z")
In sheet A, let’s say you have: - ItemID In sheet B: - Date of update (can be taken via the timestamp element of the form) - ItemID Make a multiple relation matching the ItemID in SheetA to the ItemID in SheetB, then make a rollup column of that relation, taking the Date of update from SheetB and roll by latest. ---
**Author:** ![trisixnine](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/trisixnine/32/10044_2.png) [@trisixnine](https://community.glideapps.com/u/trisixnine)\ **Post date:** [July 7, 2020, 8:51am UTC](https://community.glideapps.com/t/update-sheet-a-when-submit-form-b/12090/7 "2020-07-07T08:51:27Z")
Rollup its a good great solution, thanks!