# Using Arrayformula or similar with Glideapp form submission

**URL:** <https://community.glideapps.com/t/using-arrayformula-or-similar-with-glideapp-form-submission/7311>\
**Category:** Ask for Help\
**Created:** [April 18, 2020, 2:13pm UTC](https://community.glideapps.com/t/using-arrayformula-or-similar-with-glideapp-form-submission/7311 "2020-04-18T14:13:46Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Prichu\_Prabha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/prichu_prabha/32/2871_2.png) [@Prichu\_Prabha](https://community.glideapps.com/u/Prichu_Prabha)\
**Post date:** [April 18, 2020, 2:13pm UTC](https://community.glideapps.com/t/using-arrayformula-or-similar-with-glideapp-form-submission/7311/1 "2020-04-18T14:13:46Z")

</div>

Hi all,

I am pretty new to Glideapp, I have created an app in Glideapp for Asset management and Report submissions & i am pretty new to this…

The reports in my application are submitted via Form input from Glideapp, however, The problem raised, when i try to add a formula to Column A, which gives a unique ID based on values taken from different Column of the same row.

When i tried to use Arrayformula, whenever i submit a new form via Glideapp, the data is added to the very last row of the sheet

Arrayformula, that i used is as below:  
=ArrayFormula(If(isblank(B17:B),“”,(if(B17=“x”,“I”,“E”))&“.”&(LEFT(F17,1))&(vlookup(H17,ADVMS!A:W,22,FALSE()))))

Any help would be greatly appreciated.

BR,  
Prichu

---

<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:** [April 18, 2020, 2:26pm UTC](https://community.glideapps.com/t/using-arrayformula-or-similar-with-glideapp-form-submission/7311/2 "2020-04-18T14:26:29Z")

</div>

> [@Google Drive Not Syncing with Glide Data Tab](https://community.glideapps.com/t/google-drive-not-syncing-with-glide-data-tab/7268):
>
> My app’s URL: [runcruisecontrol.glideapp.io](http://runcruisecontrol.glideapp.io) Not sure why, but my google sheet is not in sync with that is in the glide database. When I use the app and add a row, it only shows up in the glide database. Any thoughts? Really stuck here and it’s kinda frustrating. !

---

<div class="post-metadata">

**Author:** ![Prichu\_Prabha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/prichu_prabha/32/2871_2.png) [@Prichu\_Prabha](https://community.glideapps.com/u/Prichu_Prabha)\
**Post date:** [April 19, 2020, 2:02am UTC](https://community.glideapps.com/t/using-arrayformula-or-similar-with-glideapp-form-submission/7311/3 "2020-04-19T02:02:52Z")

</div>

Great, it worked!! Thanks a lot…