Recently updated with examples: https://help...

0 3 341
3 REPLIES 3

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!

  1. Hereโ€™s the latest one I struggled with:

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.

  1. This is one that Aleksi helped someone with:

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.

Top Labels in this Space