Hello
I have created an action to set some columnsโฆ
When i test my expression i can see it works, however, when i run my action nothing happens. Iโm using a slice that has the same issue, when i test my slice i see results, but when i view it there is nothing there.
My result for the action
Hi @1111
There does not appear to be anything in the [GuardPatrolID] column. Also is it [GuardPatrolID]
or [GuardPatrol ID] with a space?
The expression result value should be in the Guard Patrol ID column
Ok , have you tried ANY(SELECTโฆ?
I am curious, is it normal to have different wording between what is shown on the top of the expression tester with the table name? I saw a โspaceโ.
Please post a screenshot of the action configuration.
Please also post a screenshot of the sliceโs row filter expression.
My sliceโs expression was:
AND([DATE]=TODAY(),[FINISH PATROL]=TRUE)
I ended up using something else as i realized that [FINISH PATROL]=TRUE was not really calculating
AND([DATE]=TODAY(),ISBLANK([FINISH PATROL])=FALSE)
However, i also found that if i use a number instead of a true/false it works:
AND([DATE]=TODAY(),[FINISH PATROL]=1)
Data types - they make all the difference.
Usually i get a warning about wrong data types, in this case there were no signs
There are a few instances where the expression builders preview results will be different than what the actual app shows.
This is due to the fact that the expression builder is something thatโs running on the AppSheet editor - while the formula for your app is being run by your app. They have different parsing mechanisms - there was a detailed post about this years ago by Phil I think.
Generally itโs just a matter of reformulating your formulas - thankfully, in AppSheet there isโฆ
If this is the formula youโre working with - the issue most likely is due to the fact that in your tables youโve got two columns that have the same name:
I would suggest changing the names of these columns so the uniquely identify each from another:
Generally speaking, itโs best to have all the columns in your app have unique names.
Try changing the names and see if that works, your formula is pretty straight-forward, so it doesnโt look like itโs a matter of a complicated formula. I recently went round and round for hours trying to solve a workflow issue - problem was due to identical column names.
User | Count |
---|---|
41 | |
36 | |
28 | |
23 | |
16 |