Hi AppSheet Community,
i recently tried to add some features to my AppSheet Project.
I want to have a Column where i add textual addition (e.g.: ‘5,2+2+7,4+23’). in a virtual column of typ “List” my App Formula is like: “=List([Textual addition])”.
now i would like to change the item separator to ‘+’ but when ever i save AppSheet changes back to ‘,’ without error or warning.
Does anybody know how to fix the problem?
finaly i want to collect the weight of products in g in one column, all the product weights schould be summarized (sum([ListOfWeights]) as also counted to get amount of Produkts (count([ListOfWeigths]). i got the function working with spreadsheet formula (count(split()) in Google spreadsheet, but i want to see the calculated values without syncing.
any help would be appreciated.