# Is there a way for a form to add data to two sheets **URL:** \ **Category:** Ask for Help\ **Created:** [July 12, 2020, 2:01am UTC](https://community.glideapps.com/t/is-there-a-way-for-a-form-to-add-data-to-two-sheets/12343 "2020-07-12T02:01:55Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Wize\_Money](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wize_money/32/10560_2.png) [@Wize\_Money](https://community.glideapps.com/u/Wize_Money)\ **Post date:** [July 12, 2020, 2:01am UTC](https://community.glideapps.com/t/is-there-a-way-for-a-form-to-add-data-to-two-sheets/12343/1 "2020-07-12T02:01:55Z")
I want to be able to take the inputs from a form and create a new data row in two separate sheets. ---
**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 12, 2020, 2:02am UTC](https://community.glideapps.com/t/is-there-a-way-for-a-form-to-add-data-to-two-sheets/12343/2 "2020-07-12T02:02:40Z")
You would need a script to do so, triggering an action to copy the values you need to the new sheet when a new row is added in the original one. ---
**Author:** ![mcclurefaith](https://avatars.discourse-cdn.com/v4/letter/m/bc8723/32.png) [@mcclurefaith](https://community.glideapps.com/u/mcclurefaith)\ **Post date:** [January 16, 2021, 3:58pm UTC](https://community.glideapps.com/t/is-there-a-way-for-a-form-to-add-data-to-two-sheets/12343/3 "2021-01-16T15:58:58Z")
I know a lot has changed in Glide since July and I’m trying to catch up. User will add a new Company to the companies sheet. Then I want to automatically add a new row to the Locations sheet, bringing in the company name and UID, and open that item to be edited (to add address, etc), then add a new row to the Profile sheet to add an employee of the company. I think I can use compound actions for this but I’m not sure how. ---
**Author:** ![wjcv06](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wjcv06/32/12747_2.png) [@wjcv06](https://community.glideapps.com/u/wjcv06)\ **Post date:** [January 16, 2021, 4:01pm UTC](https://community.glideapps.com/t/is-there-a-way-for-a-form-to-add-data-to-two-sheets/12343/4 "2021-01-16T16:01:18Z")
You can use a compound action in your form and add rows in other sheet ---
**Author:** ![mcclurefaith](https://avatars.discourse-cdn.com/v4/letter/m/bc8723/32.png) [@mcclurefaith](https://community.glideapps.com/u/mcclurefaith)\ **Post date:** [January 16, 2021, 4:12pm UTC](https://community.glideapps.com/t/is-there-a-way-for-a-form-to-add-data-to-two-sheets/12343/5 "2021-01-16T16:12:18Z")
Thank you. Yes, that’s what I’m trying to understand how to do ---
**Author:** ![wjcv06](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wjcv06/32/12747_2.png) [@wjcv06](https://community.glideapps.com/u/wjcv06)\ **Post date:** [January 16, 2021, 4:26pm UTC](https://community.glideapps.com/t/is-there-a-way-for-a-form-to-add-data-to-two-sheets/12343/6 "2021-01-16T16:26:24Z")
Take a look, you can copy the example > **[Sheet](https://ablaze-acoustics-1444.glideapp.io/)** > > Save data in more than 1 sheet ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/b/0b11683c2c2632130e084404c75325dc0d8e46f6.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/c/9cdf976d7dfda01051e8c9759ae321da7465e7db.png) ---
**Author:** ![mcclurefaith](https://avatars.discourse-cdn.com/v4/letter/m/bc8723/32.png) [@mcclurefaith](https://community.glideapps.com/u/mcclurefaith)\ **Post date:** [January 16, 2021, 5:50pm UTC](https://community.glideapps.com/t/is-there-a-way-for-a-form-to-add-data-to-two-sheets/12343/7 "2021-01-16T17:50:36Z")
Thank you, I appreciate your assistance. Yes, I’m able to create a new row in the other sheet. What action do you use to then open the details for the new row to edit it and add additional information? ---
**Author:** ![wjcv06](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wjcv06/32/12747_2.png) [@wjcv06](https://community.glideapps.com/u/wjcv06)\ **Post date:** [January 16, 2021, 6:10pm UTC](https://community.glideapps.com/t/is-there-a-way-for-a-form-to-add-data-to-two-sheets/12343/8 "2021-01-16T18:10:53Z")
You want edit information in Sheet 1 and replicated that changes in Sheet 2? or you only want edit information in Sheet 2? ---
**Author:** ![mcclurefaith](https://avatars.discourse-cdn.com/v4/letter/m/bc8723/32.png) [@mcclurefaith](https://community.glideapps.com/u/mcclurefaith)\ **Post date:** [January 16, 2021, 6:33pm UTC](https://community.glideapps.com/t/is-there-a-way-for-a-form-to-add-data-to-two-sheets/12343/9 "2021-01-16T18:33:53Z")
Edit the row just added to sheet 2 ---
**Author:** ![wjcv06](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wjcv06/32/12747_2.png) [@wjcv06](https://community.glideapps.com/u/wjcv06)\ **Post date:** [January 16, 2021, 6:35pm UTC](https://community.glideapps.com/t/is-there-a-way-for-a-form-to-add-data-to-two-sheets/12343/10 "2021-01-16T18:35:36Z")
You have to go manually to that record and edit it