Hi. I created an app that has a column which ...

(Mikey Ignacio) #1

Hi. I created an app that has a column which generates control numbers. Basically it works by concatenating the first three letters of the user email address, and the value of another column which counts how many requests the user has made. Basically if my email address is mikey@gmail.com and I am creating my third request, the control number should be MIK3. It works so far but we have a user with the email address mark**@gmail.com, what happens is appsheet converts the control number into a date. For example his first request, MAR1 is converted into Mar-1 in the back end(database) which just comes out as numbers in the front end. Is there any possible workaround to this without changing the ctrl number format? Thanks in advance!

(Aleksi Alkio) #2

Set the column type to “Plain Text” on your spreadsheet and it should do the trick.

(Mikey Ignacio) #3

@Aleksi_Alkio wow it’s so obvious but I didn’t notice it. Thank you so much I’ve been getting frustrated for hours about this!

(Aleksi Alkio) #4

You’re welcome