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