Hello Guys, I have a field in my app to scan...

(PADC) #1

Hello Guys,

I have a field in my app to scan VIN#

from cars, VIN#'s have 17 digits but I only need the last 8, using the RIGHT formula in the spreadsheet I can filter. My question is: Can I use the RIGHT formula inside the app to have the data already filtered before send to the spreadsheet?

Thanks.

(Aleksi Alkio) #2

You can’t filter the VIN# at the same time when you are recording it. You need to create an additional column for that purpose OR you can create an action and the saving will trigger it. After savig it will then filter that value.

(PADC) #3

@Aleksi_Alkio Thank you. Translate