# Is it possible to keep the last entries in a form? **URL:** \ **Category:** Ask for Help\ **Created:** [April 16, 2024, 10:09am UTC](https://community.glideapps.com/t/is-it-possible-to-keep-the-last-entries-in-a-form/72617 "2024-04-16T10:09:00Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Andreea\_Nisipeanu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/andreea_nisipeanu/32/62787_2.png) [@Andreea\_Nisipeanu](https://community.glideapps.com/u/Andreea_Nisipeanu)\ **Post date:** [April 16, 2024, 10:09am UTC](https://community.glideapps.com/t/is-it-possible-to-keep-the-last-entries-in-a-form/72617/1 "2024-04-16T10:09:00Z")
Hello! Is it possible to keep the last entries in a form based of what the last user chose to select in the form entries? Thanks! ---
**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:** [April 16, 2024, 1:03pm UTC](https://community.glideapps.com/t/is-it-possible-to-keep-the-last-entries-in-a-form/72617/2 "2024-04-16T13:03:25Z")
In the user profile table or the the table linked to the screen that contains your form button, you could create some single value columns that retrieve that last row values form the form’s destination table. Then use those values to set the default on the components within the form. ---
**Author:** ![Andreea\_Nisipeanu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/andreea_nisipeanu/32/62787_2.png) [@Andreea\_Nisipeanu](https://community.glideapps.com/u/Andreea_Nisipeanu)\ **Post date:** [April 16, 2024, 1:13pm UTC](https://community.glideapps.com/t/is-it-possible-to-keep-the-last-entries-in-a-form/72617/3 "2024-04-16T13:13:24Z")
It doesn’t work with big table. You know another way? ---
**Author:** ![Andreea\_Nisipeanu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/andreea_nisipeanu/32/62787_2.png) [@Andreea\_Nisipeanu](https://community.glideapps.com/u/Andreea_Nisipeanu)\ **Post date:** [April 16, 2024, 1:23pm UTC](https://community.glideapps.com/t/is-it-possible-to-keep-the-last-entries-in-a-form/72617/4 "2024-04-16T13:23:32Z")
Single value doesn’t work, but can I use something else (excel formula)? ---
**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:** [April 16, 2024, 1:42pm UTC](https://community.glideapps.com/t/is-it-possible-to-keep-the-last-entries-in-a-form/72617/5 "2024-04-16T13:42:43Z")
I haven’t used Big Tables, so I’m not fluent on what you can and can’t do with them. @Darren_Murphy may have a better answer regarding that. The alternative may be an On Submit action that writes certain values to the user profile table, and then you can retrieve them for your defaults. ---
**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:** [April 16, 2024, 1:51pm UTC](https://community.glideapps.com/t/is-it-possible-to-keep-the-last-entries-in-a-form/72617/6 "2024-04-16T13:51:19Z")
Just so I’m clear on what you are wanting: - User A submits a form - Sometime later, User B opens the same form - User B should see the values that User A submitted as default values - And the form is submitting to a Big Table Correct? ---
**Author:** ![Andreea\_Nisipeanu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/andreea_nisipeanu/32/62787_2.png) [@Andreea\_Nisipeanu](https://community.glideapps.com/u/Andreea_Nisipeanu)\ **Post date:** [April 16, 2024, 1:53pm UTC](https://community.glideapps.com/t/is-it-possible-to-keep-the-last-entries-in-a-form/72617/8 "2024-04-16T13:53:58Z")
Yes ---
**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:** [April 16, 2024, 2:03pm UTC](https://community.glideapps.com/t/is-it-possible-to-keep-the-last-entries-in-a-form/72617/9 "2024-04-16T14:03:58Z")
I think you could use a variation of what Jeff suggested. But instead of writing the values directly to the User Profile row, write them to a single row helper table, then use single value columns to pull them into the User Profile row. So: - Create a table and add a single row (if you add a RowID column, that will happen automatically) - Add a column for each value that you need. Do not use User Specific columns. - Add a corresponding single value column for each one in your User Profiles table - Use an onSubmit Set Column Values action with your form to update the values in the Helper Table (you may need to add a Single Value → First → Whole row column to the User Profile to facilitate this) - Use the Single Value columns in the User Profile as defaults for the form. There is a potential race condition if two users happen to open the form at the same time, in that they would both get the same default values. That may or may not be an issue 🤷‍♂️ ---
**Author:** ![Andreea\_Nisipeanu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/andreea_nisipeanu/32/62787_2.png) [@Andreea\_Nisipeanu](https://community.glideapps.com/u/Andreea_Nisipeanu)\ **Post date:** [April 18, 2024, 6:21am UTC](https://community.glideapps.com/t/is-it-possible-to-keep-the-last-entries-in-a-form/72617/10 "2024-04-18T06:21:45Z")
Thank you @Darren_Murphy. I think it is a good solution. There is no problem with the users getting the same values. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [April 25, 2024, 6:22am UTC](https://community.glideapps.com/t/is-it-possible-to-keep-the-last-entries-in-a-form/72617/11 "2024-04-25T06:22:10Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.