Recently updated with examples:
https://help.appsheet.com/expressions/functions/date https://help.appsheet.com/expressions/functions/datetime https://help.appsheet.com/expressions/functions/time
Any other examples youโd like to see in these?
Thanks for doing these.
IN and CONTAINS would be good.
I found these guides great when I started out with Appsheet, and I still refer to them.
Where I struggle, now, is with more complex expressions, e.g., one that requires a combination (in the right sequence) of IN, SELECT, AND, NOT, ISBLANK, (_THIS) with the right select filter(s) in the right place.
At the moment, I scour the forum, looking for similar, complex expressions, and try to infer what mine should look like.
More complex expression examples would be much appreciated, though I can see that they are more difficult to provide guidance for.
IN() and CONTAINS() are coming, as are the rest, but itโs slow-going because I have very limited time.
Iโm very interested in knowing what sort of complex expressions would be helpful. Can you provide some suggestions?
Anything you can do to increase the body of easy-to-find knowledge is very much appreciated and, given your limited time, you are churning out guidance at a jaw-dropping rate!
Linktofilteredview(AuditBaseQs, OR(IN([BaseQID], Select(Controls[RelatedBaseQs], IN([_Thisrow].[ActivityID], [RelatedActivities]))), IN([BaseQID], Select(Standards[RelatedBaseQs], IN([_Thisrow].[ActivityID], [RelatedActivities])))))
This pulls all the Base Questions related to the current Activity.
The Base Questions table has refs to and is populated from the Controls and Standards tables and I needed to pull the BaseQs from the Ref_Rows in each of the two tables, IF the tables Ref-Rows of Activities contained the current Activity.
SELECT(TableName[STATUS],[PROJECT]=[_THISROW].[PROJECT] + LIST([_THIS])
Iโm fine with this, up until the โ+ LIST([_THIS])โ bit!
Aleksi then upped the anti with:
SELECT(TableName[STATUS],[PROJECT]=[_THISROW].[PROJECT] + SELECT(TableName[STATUS],[KeyColumn]=[_THISROW].[KeyColumn])
I guess the โ+โ adds. the lists.
Take a deep breathโฆ
One that Aleksi put into a sample app for me:
=IF(IN([ID],Schedule[ID]), SELECT(Roles[COURSES],IN([ROLE],[_THISROW].[ROLE]),TRUE)SELECT(Schedule[COURSE],AND([EMP]=[_THISROW].[EMP],NOT([ID]=[_THISROW].[ID]))), (SELECT(Roles[COURSES],IN([ROLE],[_THISROW].[ROLE]),TRUE)-SELECT(Schedule[COURSE],[EMP]=[_THISROW].[EMP])))
Iโm not saying any guidance should have examples this complex, but it would be good to have simple examples of things like: A. โ+โ and โโ of lists
B. the logic to the order in which expression parts should be put together for a working expression
C.
How, when and where to use, (_This).
Try searching for the phrases, โ(_This)โ or โIN(โ or โAND(โ or โNOT(IN(โ in this forum or from the main Appsheet Customer Support page.
D.
Expression/statement techniques to use when an app contains a junction table to provide many-to-many relationship functionality (junction tables are great, but they do demand more complex expressions)
You and others on the forum are great at providing guidance to specific problems, and I suspect thereโs a lot of guidance in the forum that I miss out on, simply because it is difficult to pinpoint.
User | Count |
---|---|
61 | |
25 | |
14 | |
11 | |
6 |