i am using appsheet since a few months, and we will start to use it for our company shortly.
In short, our customers (dealers) will get a monthly review of some 20-30 products with some characteristics (price, title, description etc). Via the app they have a say, through filling out a form, in whether or not they want the proposed product selection in their monthly promo flyer or not (which we supply for them), at which sales price etc., hence we get a customized flyer for each dealer.
Now, every month the list with items changes, except for the first few items (Name, Customer number, TimeStamp). If I change the source data in my sheet all column types need to be updated again, whereas the sequence always remain the same (Y/N, Price, Price, Number, Show).
Is there a way to fix this without manually updating this every month ?
I know you can start the source data with “is_____” to get a boolean (Y/N) and that “Amount” automatically converts to the Number data type. But that doesn’t fully cover my needs.
Also, Is there a way to put the standard currency on EURO instead of Dollar?