# Editing by multiple users at the same time

**URL:** <https://community.glideapps.com/t/editing-by-multiple-users-at-the-same-time/5853>\
**Category:** Ask for Help\
**Created:** [March 25, 2020, 8:45pm UTC](https://community.glideapps.com/t/editing-by-multiple-users-at-the-same-time/5853 "2020-03-25T20:45:36Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![JMP](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jmp/32/1379_2.png) [@JMP](https://community.glideapps.com/u/JMP)\
**Post date:** [March 25, 2020, 8:45pm UTC](https://community.glideapps.com/t/editing-by-multiple-users-at-the-same-time/5853/1 "2020-03-25T20:45:36Z")

</div>

I am working on a savings calculator for refinancing a mortgage. There are several fields that an individual needs to edit by inputting their specific information. This works great if there is only one person editing the information, but if two people are using the app, the edits by user 2 will overwrite the user one’s input, causing the calculations to change and the information to no longer be accurate. I want the app to be used by anyone that might want the information. So, I don’t have all the email addresses for all the potential users. I was trying to figure out if I could create another row that would then be take the edits of the second user only, leaving the first user’s info untouched, but I can’t figure out how to make that work. Any thoughts?

---

<div class="post-metadata">

**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\
**Post date:** [March 25, 2020, 8:47pm UTC](https://community.glideapps.com/t/editing-by-multiple-users-at-the-same-time/5853/2 "2020-03-25T20:47:21Z")

</div>

Use a form?

---

<div class="post-metadata">

**Author:** ![JMP](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jmp/32/1379_2.png) [@JMP](https://community.glideapps.com/u/JMP)\
**Post date:** [March 25, 2020, 8:51pm UTC](https://community.glideapps.com/t/editing-by-multiple-users-at-the-same-time/5853/3 "2020-03-25T20:51:10Z")

</div>

Would that work you think? I don’t know much about using forms, but if that would allow multiple users to enter info and get the resulting figures without another user’s input changing their info, I would be all about learning how to use a form. Any certain video or resource you would recommend to learn more?

---

<div class="post-metadata">

**Author:** ![JMP](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jmp/32/1379_2.png) [@JMP](https://community.glideapps.com/u/JMP)\
**Post date:** [March 25, 2020, 9:50pm UTC](https://community.glideapps.com/t/editing-by-multiple-users-at-the-same-time/5853/4 "2020-03-25T21:50:45Z")

</div>

I am messing around with this now. Is there a way to get the form submission information back into the Google sheet for calculation and then display of the resulting figures? Thank you!

---

<div class="post-metadata">

**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\
**Post date:** [March 25, 2020, 11:00pm UTC](https://community.glideapps.com/t/editing-by-multiple-users-at-the-same-time/5853/5 "2020-03-25T23:00:00Z")

</div>

Form submissions automatically go to you sheet, that’s how forms work: [https://docs.glideapps.com/all/guides/quick-starts/intermediate-techniques/forms](https://docs.glideapps.com/all/guides/quick-starts/intermediate-techniques/forms)

Then you can use that data in calculations or other parts of your app.

---

<div class="post-metadata">

**Author:** ![JMP](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jmp/32/1379_2.png) [@JMP](https://community.glideapps.com/u/JMP)\
**Post date:** [March 26, 2020, 6:45pm UTC](https://community.glideapps.com/t/editing-by-multiple-users-at-the-same-time/5853/6 "2020-03-26T18:45:20Z")

</div>

Thank you David - For some reason, yesterday, the form was only writing to the Data sheet. I recreated the form on my laptop, and it did write to the Google sheet as well and isn’t writing over the first users info, which is great! Do you know how I can get the formulas in my main sheet to read the from the most recent data in the Form Submission tab? I hope you don’t mind the questions!

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [March 28, 2020, 4:09pm UTC](https://community.glideapps.com/t/editing-by-multiple-users-at-the-same-time/5853/7 "2020-03-28T16:09:15Z")

</div>

Here’s another thread on creating a calculator.

> [@Any thoughts on a Glide version of calculator?](https://community.glideapps.com/t/any-thoughts-on-a-glide-version-of-calculator/5919):
>
> Hi folks, I tried to build a Glide version of calculator, with a particular formula I predefined. Basically, I would like to see each user can input numbers in cell a, b, c, d respectively. And then the built-in math function of Glide (see the predefined formula below) will automatically return two values like in the picture below. I know how to use the math function to do the division and multiplication. I can obtain the two values. But I have no idea how to make sure eac…

Right now you would need to enable email sign in to only allow a user to see their own calculations.

The simplest way to only show the last calculated item would be to change your tab to the detail style layout, and set the sort order to reverse order, so that latest item is on top. The detail style layout only displays the first record in a sheet (that matches any filtering and sorting)

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/7/73862cc96d355852eb2f295293c95666cc22662d.png)

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [January 27, 2024, 6:44pm UTC](https://community.glideapps.com/t/editing-by-multiple-users-at-the-same-time/5853/8 "2024-01-27T18:44:00Z")

</div>


