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.
br Bernhard
The reversion of the list item separator is a long-standing bug. I encourage you to report it to support@appsheet.com.
Values computed by the spreadsheet cannot be visible to the app without a sync; a sync is required.
Hello steve, thanks for your reply. I will post to support.
@Landwirtschaftlicher Iโm a bit confused about the intent. By replacing the list separator with a โ+โ, are you intending for some part of the system to then execute the sum of the list that way?
@praveen No, in Austria we define a komma like it is, so 0,5+1,6+2,5 would be separated in 0|5+1|6+2|5 when the list separator is standard โ,โ but i need to separate the list like this โ0,5|1,6|2,5โ -> so i just need a different separator than โ,โ it probably could be a โ#โ also or anything else. but finally i want to summarize the list so it is much closer to use a โ+โ sign as separator.
User | Count |
---|---|
41 | |
36 | |
28 | |
23 | |
16 |