# Action to add form

**URL:** <https://community.glideapps.com/t/action-to-add-form/30751>\
**Category:** Ask for Help\
**Created:** [August 21, 2021, 6:06am UTC](https://community.glideapps.com/t/action-to-add-form/30751 "2021-08-21T06:06:04Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![Wim\_De\_Coninck](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wim_de_coninck/32/28179_2.png) [@Wim\_De\_Coninck](https://community.glideapps.com/u/Wim_De_Coninck)\
**Post date:** [August 21, 2021, 6:06am UTC](https://community.glideapps.com/t/action-to-add-form/30751/1 "2021-08-21T06:06:04Z")

</div>

Hi,

how can I create a custom action for a button to go directly to the add-form (“+”) of a specific tab?  
Of course, I can go to that tab, but then I tried “show Form screen” and “show New screen” but without result.

Wim

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [August 21, 2021, 6:08am UTC](https://community.glideapps.com/t/action-to-add-form/30751/2 "2021-08-21T06:08:48Z")

</div>

action " Show Form Screen "

---

<div class="post-metadata">

**Author:** ![Wim\_De\_Coninck](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wim_de_coninck/32/28179_2.png) [@Wim\_De\_Coninck](https://community.glideapps.com/u/Wim_De_Coninck)\
**Post date:** [August 21, 2021, 7:51am UTC](https://community.glideapps.com/t/action-to-add-form/30751/3 "2021-08-21T07:51:49Z")

</div>

thanks, but this seems to be another form than the “normal” add-form when tapping on “+”

---

<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 21, 2021, 8:15am UTC](https://community.glideapps.com/t/action-to-add-form/30751/4 "2021-08-21T08:15:29Z")

</div>

You can just copy all components from your configured add screen to that form (special values and on-submit action won’t be copied over).

---

<div class="post-metadata">

**Author:** ![Wim\_De\_Coninck](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wim_de_coninck/32/28179_2.png) [@Wim\_De\_Coninck](https://community.glideapps.com/u/Wim_De_Coninck)\
**Post date:** [August 21, 2021, 8:27am UTC](https://community.glideapps.com/t/action-to-add-form/30751/5 "2021-08-21T08:27:34Z")

</div>

OK and I think I can do this with your help.  
But there’s still the question why Glide uses 2 different forms, one “add form” (with “+”) and another one when using actions…

---

<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 21, 2021, 9:10am UTC](https://community.glideapps.com/t/action-to-add-form/30751/6 "2021-08-21T09:10:48Z")

</div>

The “+” is restricted for list views, to specifically add rows to the Sheet you’re using on that screen. When you switch to a details view that option can not be enabled anymore.

---

<div class="post-metadata">

**Author:** ![Fred\_Marker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fred_marker/32/27977_2.png) [@Fred\_Marker](https://community.glideapps.com/u/Fred_Marker)\
**Post date:** [August 21, 2021, 5:19pm UTC](https://community.glideapps.com/t/action-to-add-form/30751/7 "2021-08-21T17:19:15Z")

</div>

Are these “rules” documented anywhere in written form? If not, why not?

Many if not most of the learning modules are pre 2.0 interface. It’s hard to pick up on and memorize all of the “rules” contained in video tutorials. It is much more helpful and efficient to search and browse written documentation that clearly states what you can and cannot do or what you should or should not do.

How about creating a new Category in this forum dedicated to written documentation with separate topics for “forms”, “screens”, “actions”, “user profile”, “components”, etc.? Allow only certified experts to post/edit content (do not permit frivolous responses or chatting) and allow read only access to everyone.

---

<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 21, 2021, 10:53pm UTC](https://community.glideapps.com/t/action-to-add-form/30751/8 "2021-08-21T22:53:06Z")

</div>

I believe Glide is in the process of updating all documentations to match the 2.0 version. Your idea is nice though, at the moment we’re willing to answer things for users here in the forum, and it would be great to have one centralized place to store those as a wiki to refer to.

---

<div class="post-metadata">

**Author:** ![Wim\_De\_Coninck](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wim_de_coninck/32/28179_2.png) [@Wim\_De\_Coninck](https://community.glideapps.com/u/Wim_De_Coninck)\
**Post date:** [August 25, 2021, 3:56pm UTC](https://community.glideapps.com/t/action-to-add-form/30751/9 "2021-08-25T15:56:03Z")

</div>

I noticed that adding data with the action “show form screen” isn’t synchronized with the underlying Google Sheet.  
I can only see the new data in the Glide table (visible with the small table icon above the editor).

Is this a bug? Or did I do something wrong?  
Wim

---

<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:** [August 25, 2021, 4:02pm UTC](https://community.glideapps.com/t/action-to-add-form/30751/10 "2021-08-25T16:02:56Z")

</div>

Same question, but now I’m wondering if we have a larger problem here. This is the third report this morning.

> [@Not able to display value in sheet](https://community.glideapps.com/t/not-able-to-display-value-in-sheet/30928/21):
>
> Are you using a free or pro app? Have you exceeded you limit on sheet edits for the month?

---

<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:** [August 25, 2021, 4:53pm UTC](https://community.glideapps.com/t/action-to-add-form/30751/11 "2021-08-25T16:53:04Z")

</div>

Also, are you sure the data is not at the very bottom of the sheet?

---

<div class="post-metadata">

**Author:** ![Wim\_De\_Coninck](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wim_de_coninck/32/28179_2.png) [@Wim\_De\_Coninck](https://community.glideapps.com/u/Wim_De_Coninck)\
**Post date:** [August 25, 2021, 7:16pm UTC](https://community.glideapps.com/t/action-to-add-form/30751/12 "2021-08-25T19:16:56Z")

</div>

Good suggestion and indeed…  
I had 3 rows with data in the (test-)sheet and added (within GS) some lookup formulas in new columns. Then I copied those formulas to row 100 (to be used with every new data-line).  
Now, my 4th added data is on line 101. Instead of on line 4

So, it’s not a bug, but Glide thinks those formulas are data-lines and add the 4th input below.  
Not totally unlogic, but this brings me to some problems, as vlookup and importrange-formulas are not possible within Glide.  
I’ll try to delete those formulas in my sheet and adding an new sheet in my GS with vlookup-linking to my original sheet and add those formulas there.

---

<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:** [August 25, 2021, 7:40pm UTC](https://community.glideapps.com/t/action-to-add-form/30751/13 "2021-08-25T19:40:49Z")

</div>

Can you explain your formulas in more detail? Is it something that could be done in glide with relations and lookups? There are better ways to handle formulas in google sheets, such as arrayformulas, but if you can do the same thing with glide columns, then you are much better off.

---

<div class="post-metadata">

**Author:** ![Pooja\_Kumar](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pooja_kumar/32/30344_2.png) [@Pooja\_Kumar](https://community.glideapps.com/u/Pooja_Kumar)\
**Post date:** [August 26, 2021, 4:11am UTC](https://community.glideapps.com/t/action-to-add-form/30751/14 "2021-08-26T04:11:00Z")

</div>

The sheet includes very complex calculations. Team has been working on the sheet for very long & that’s the preferred medium. Everything was working fine till day before midnight. We’ve been facing this issue since yesterday morning.

Attaching screenshots FYR:

1. A/c status - spare space/edits etc

Pls. help

 ![Screenshot (526)](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/c/2c51446b6b663db46046a0fff12e012e2ec0ff21.jpeg)

---

<div class="post-metadata">

**Author:** ![Pooja\_Kumar](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pooja_kumar/32/30344_2.png) [@Pooja\_Kumar](https://community.glideapps.com/u/Pooja_Kumar)\
**Post date:** [August 26, 2021, 4:21am UTC](https://community.glideapps.com/t/action-to-add-form/30751/15 "2021-08-26T04:21:53Z")

</div>

Its not.  
Sharing screenshots FYR: [Glide Issue - Edits in app not getting reflected in GSpreadsheet - Google Drive](https://drive.google.com/drive/folders/10U0WUp1d2KY9VYKNK46lLjI1X4_2fVAW?usp=sharing)

1. App front end where we chaged value of Fixed pay from 40 to 30 (for pooja@venex.co.in)
2. Glide Table where change is reflecting
3. Spreadsheet where it is still showing 40 (original value)  
Unless change reflects in GSheet, re-calculations cannot be done & output cannot be displayed back.  
Kindly help

---

<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:** [August 26, 2021, 4:35am UTC](https://community.glideapps.com/t/action-to-add-form/30751/16 "2021-08-26T04:35:53Z")

</div>

Your sheet tab appears to be locked. Are you sure Glide has access to update that particular sheet tab?

---

<div class="post-metadata">

**Author:** ![Pooja\_Kumar](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pooja_kumar/32/30344_2.png) [@Pooja\_Kumar](https://community.glideapps.com/u/Pooja_Kumar)\
**Post date:** [August 26, 2021, 5:08am UTC](https://community.glideapps.com/t/action-to-add-form/30751/17 "2021-08-26T05:08:57Z")

</div>

We locked the sheets 3 days back and all was working fine untill 2 days back, so don’t think that is an issue. Have unlocked them now. But issue still persists.

---

<div class="post-metadata">

**Author:** ![Pooja\_Kumar](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pooja_kumar/32/30344_2.png) [@Pooja\_Kumar](https://community.glideapps.com/u/Pooja_Kumar)\
**Post date:** [August 26, 2021, 7:57am UTC](https://community.glideapps.com/t/action-to-add-form/30751/18 "2021-08-26T07:57:31Z")

</div>

I suspect another issue. A team member transferred ownership of the GSheet to my personal ID pooja0402@gmail, roughly the same time that the app stopped syncing with the sheet. pooja0402@gmail was not part of the Glide Team on VenEx. I have since been trying to add pooja0402@gmail to the Glide Team on VenEx but that is not happening!! Pls. see the process am following, yet am not part of the team as yet. Have tried using invite link also which shows Join Team but as faded (not an avtive button): [Glide issue- Data not syncing into spreadsheet. Unable to add Team member - Google Drive](https://drive.google.com/drive/folders/1mGajZuXJN6oSk83GahuwyURF-FdBZwnk?usp=sharing)  
Kindly help fix this, maybe after that this may work.

---

<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 26, 2021, 9:05am UTC](https://community.glideapps.com/t/action-to-add-form/30751/19 "2021-08-26T09:05:55Z")

</div>

Weird that you see the messsage “could not find that invite”. Have you tried the invite link with another email? Does it show the same message?

---

<div class="post-metadata">

**Author:** ![Pooja\_Kumar](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pooja_kumar/32/30344_2.png) [@Pooja\_Kumar](https://community.glideapps.com/u/Pooja_Kumar)\
**Post date:** [August 26, 2021, 9:31am UTC](https://community.glideapps.com/t/action-to-add-form/30751/20 "2021-08-26T09:31:07Z")

</div>

We already have 6 more people in the Team & they all joint via this method over the past few weeks.

[Next page](https://community.glideapps.com/t/action-to-add-form/30751.md?page=2)
