Unique ID, manual generation
=ArrayFormula( IF( LEN(A2:A) , LEFT(โGeneral Dataโ!G2:G,1)&LEFT(โGeneral Dataโ!E2:E)&SUBSTITUTE(TEXT( I2:I ,โddMMYYHH:mmโ ),":","") , IFERROR(1/0) ) )
I have a formula in my google sheet that generates a unique ID, combining the initials of the name of the patient with the date/time of admission. However, I canโt use it as a key since it has a formula on the google sheet cell. I tried to mimic this formula with appsheet but so far failed. I tried using concatenate() and initials() but failed. Any idea on how I can go about this?
Thank you
What have you tried already?
I have found out a way already by making a virtual column with concant, thanks.
Good
User | Count |
---|---|
38 | |
34 | |
27 | |
23 | |
17 |