# Was this ever solved? Submitting forms without showing a form

**URL:** <https://community.glideapps.com/t/was-this-ever-solved-submitting-forms-without-showing-a-form/29816>\
**Category:** Ask for Help\
**Created:** [July 31, 2021, 9:28pm UTC](https://community.glideapps.com/t/was-this-ever-solved-submitting-forms-without-showing-a-form/29816 "2021-07-31T21:28:17Z")\
**Posts on this page:** 14\
**Page:** 1

<div class="post-metadata">

**Author:** ![pete3905](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pete3905/32/4191_2.png) [@pete3905](https://community.glideapps.com/u/pete3905)\
**Post date:** [July 31, 2021, 9:28pm UTC](https://community.glideapps.com/t/was-this-ever-solved-submitting-forms-without-showing-a-form/29816/1 "2021-07-31T21:28:17Z")

</div>

Perrin

1  
Feb '20  
I have a form that is only submitting data that the user does not have to enter. Is there way to not have it to take the user to a blank screen to Click - Submit?

---

<div class="post-metadata">

**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\
**Post date:** [July 31, 2021, 9:41pm UTC](https://community.glideapps.com/t/was-this-ever-solved-submitting-forms-without-showing-a-form/29816/2 "2021-07-31T21:41:43Z")

</div>

You can create columns user-specific and use the action **Add Row**

Have you ever tried?

---

<div class="post-metadata">

**Author:** ![AyS\_0908](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ays_0908/32/27349_2.png) [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)\
**Post date:** [July 31, 2021, 11:01pm UTC](https://community.glideapps.com/t/was-this-ever-solved-submitting-forms-without-showing-a-form/29816/3 "2021-07-31T23:01:24Z")

</div>

As @Lucas_Pires said, I use it regularly, it works very well: a simple button + add row

---

<div class="post-metadata">

**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 31, 2021, 11:04pm UTC](https://community.glideapps.com/t/was-this-ever-solved-submitting-forms-without-showing-a-form/29816/4 "2021-07-31T23:04:20Z")

</div>

If you don’t need users to fill anything then I think you only need a button to add rows using your screen values or user profile values, not necessarily user-specific columns.

---

<div class="post-metadata">

**Author:** ![pete3905](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pete3905/32/4191_2.png) [@pete3905](https://community.glideapps.com/u/pete3905)\
**Post date:** [August 2, 2021, 7:14pm UTC](https://community.glideapps.com/t/was-this-ever-solved-submitting-forms-without-showing-a-form/29816/5 "2021-08-02T19:14:04Z")

</div>

OK, thank you.  
I have gotten the add row to work however I do not understand how to fully populate the row.

What I am doing is having the user enter an amount of “A” and then the Sheet calculates and displays the amount of “B” to add for the correct ratio.

I’ve got this portion working and it populates the new row with the user ID (email), amount of “A” and amount of “B” but I can’t figure out how to populate the timestamp field. I guess because this is actually form time. Any way to add a timestamp for “add row time”?

Thanks

---

<div class="post-metadata">

**Author:** ![AyS\_0908](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ays_0908/32/27349_2.png) [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)\
**Post date:** [August 2, 2021, 8:10pm UTC](https://community.glideapps.com/t/was-this-ever-solved-submitting-forms-without-showing-a-form/29816/6 "2021-08-02T20:10:39Z")

</div>

When building your form, did you try to add some fields from the “screen columns”?  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/8/68870175bf2eb3b1d2268d08671df2b7b6926aa9.png)

---

<div class="post-metadata">

**Author:** ![pete3905](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pete3905/32/4191_2.png) [@pete3905](https://community.glideapps.com/u/pete3905)\
**Post date:** [August 2, 2021, 9:10pm UTC](https://community.glideapps.com/t/was-this-ever-solved-submitting-forms-without-showing-a-form/29816/7 "2021-08-02T21:10:55Z")

</div>

Thank you, it worked.  
Now, I have a trigger set up to clear the fields when a row is added. Is there any way to make that data “stick” in the users app screen for “X” amount of time, or until the next time they open the app?

---

<div class="post-metadata">

**Author:** ![AyS\_0908](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ays_0908/32/27349_2.png) [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)\
**Post date:** [August 2, 2021, 9:28pm UTC](https://community.glideapps.com/t/was-this-ever-solved-submitting-forms-without-showing-a-form/29816/8 "2021-08-02T21:28:43Z")

</div>

I never tried, but did you combine

- custom action: set column \> “clear value”
- component “Stop watch”?

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/5/b5fc114738b9d4b09d5f6b17da94abe113e7d3bc.png)

---

<div class="post-metadata">

**Author:** ![pete3905](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pete3905/32/4191_2.png) [@pete3905](https://community.glideapps.com/u/pete3905)\
**Post date:** [August 2, 2021, 9:53pm UTC](https://community.glideapps.com/t/was-this-ever-solved-submitting-forms-without-showing-a-form/29816/9 "2021-08-02T21:53:48Z")

</div>

Would have no idea how to combine those 2.

---

<div class="post-metadata">

**Author:** ![AyS\_0908](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ays_0908/32/27349_2.png) [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)\
**Post date:** [August 3, 2021, 6:49am UTC](https://community.glideapps.com/t/was-this-ever-solved-submitting-forms-without-showing-a-form/29816/10 "2021-08-03T06:49:29Z")

</div>

Neither do I, but there are many posts in the forum about Stopwatch

---

<div class="post-metadata">

**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:** [August 3, 2021, 8:16am UTC](https://community.glideapps.com/t/was-this-ever-solved-submitting-forms-without-showing-a-form/29816/11 "2021-08-03T08:16:49Z")

</div>

> [@pete3905](#):
>
> I’ve got this portion working and it populates the new row with the user ID (email), amount of “A” and amount of “B” but I can’t figure out how to populate the timestamp field.

Sounds like your timestamp can just be populated by the special “current time” field in the form.

> [@pete3905](#):
>
> Now, I have a trigger set up to clear the fields when a row is added. Is there any way to make that data “stick” in the users app screen for “X” amount of time, or until the next time they open the app?

Can you explain why do you need to clear the fields here and what fields do you clear? What is the “trigger”?

---

<div class="post-metadata">

**Author:** ![pete3905](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pete3905/32/4191_2.png) [@pete3905](https://community.glideapps.com/u/pete3905)\
**Post date:** [August 3, 2021, 1:50pm UTC](https://community.glideapps.com/t/was-this-ever-solved-submitting-forms-without-showing-a-form/29816/12 "2021-08-03T13:50:41Z")

</div>

Based on this post this is a no go:

> [@Glideapp Update frequency](https://community.glideapps.com/t/glideapp-update-frequency/9372/44):
>
> No, its a stopwatch. Thats all it does. You can’t use it to tie into other actions or as a result of an action, its a manual timer, needs to be started and stopped by a human and has no additional features other than counting time or counting down time for you. It’s just a stopwatch.

---

<div class="post-metadata">

**Author:** ![pete3905](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pete3905/32/4191_2.png) [@pete3905](https://community.glideapps.com/u/pete3905)\
**Post date:** [August 3, 2021, 2:35pm UTC](https://community.glideapps.com/t/was-this-ever-solved-submitting-forms-without-showing-a-form/29816/13 "2021-08-03T14:35:02Z")

</div>

I did get the timestamp working. Thank you.

The app shows the user the results of the ratio calculation from the top row of the GSheet. I have an onchange trigger which clears those results when a new row containing user email, timestamp, amount of “A” and amount of “B” is added. This also clears the results from the UI. I need those results to “stick” in the UI for some amount of time as the operation the user is performing will take, lets say, 5 minutes and the user may need to refer back to the results.

My goal is to avoid having the user have to click on the form submit because they will probably forget and then the next user will have erroneous data populated which could cause confusion and/or mistakes.

So, perfect world = User enters amount of “A” and hits Calculate Dose button. Dose is calculated and displayed on the same screen and data is added to new row on Gsheet. Displayed dose data is available to user for “X” time or until app is closed.

---

<div class="post-metadata">

**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\
**Post date:** [August 20, 2021, 3:52pm UTC](https://community.glideapps.com/t/was-this-ever-solved-submitting-forms-without-showing-a-form/29816/14 "2021-08-20T15:52:25Z")

</div>

I don’t use Glide anymore but I posted a generic cron system using java on the backend of google sheets. I can’t rwmwmbwe where but you could look through my posts for it. I have switched to [nullkode.io](http://nullkode.io) and adalo depending on what I need.

[nullkode.io](http://nullkode.io) literally builds the app for you using modules and they provide source code for all apps as well as PWA’s at no additional cost. So when I’m done with my app I don’t have to keep paying ppl for it. I own it forever.
