I have an EnumList in which the allowed options are controlled by a ValidIf constraint, based on selection on another field.
SWITCH([REQUEST TYPE],
"IPG", LIST("Visa","Mastercard","JCB","CUP"),
"EMAILPAY", LIST("Visa","Mastercard","JCB","CUP"),
"Online SIP", LIST("Visa","Mastercard"),
"MKI", LIST("Visa","Mastercard","JCB","CUP"),
"EMOTO", LIST("Visa","Mastercard","JCB","CUP"),
LIST("Visa","Mastercard","Bancnet Debit",
"BPI Debit","JCB","CUP","AMEX","AliPay","Ayala Card","Petron Card")
)
When entered manually, it works perfectly fine.
However, I have activated the CSV upload option, and entries are entered separated by comma.
However, appsheet rejects this. It only goes through if only one item is entered in the CSV column.
Any help please.
User | Count |
---|---|
35 | |
35 | |
28 | |
23 | |
18 |