AppSheet Office Hours: How to Use and Optimize App Expressions

Hi!  I'm quite late but just catching up on this now.  I'm partway through the video and am interested in Derek's demonstration.  Was this app made available to us as a template that we can copy and play with on our own?  If not, I'd like to request that in similar situations in the future, all demonstration apps be made available as templates.

Any road map on the AppSheet first party database?

QUESTION : Feasibility of a WITH() function to clarify complex expressions

Would it be possible for AppSheet to add a WITH() function, similar in concept to the WITH clause available in SQL queries ?

Syntax

WITH(constant-name1, constant-value1, [constant-name2, constant-value2...], result)

How it works

• The WITH function allows to decompose a complex expression into sub-expressions
• A constant-value can be any expression which is evaluated and assigned to the constant-name
• The result (and a constant-value) can refer to a previous assigned constant-name by prefixing it with _CONST
• The WITH function returns the evaluation of the result expression

Benefits

• Self documenting expressions without requiring inline comments
• Avoid repeating identical sub-expressions and improve performance
• Clarify a complex expression by breaking it down without using virtual columns

Example

A table security filter expression returns TRUE for the rows of table employee that should be loaded in a HR App, where the user works on a subset of employees at a time. The filter condition is :

• The employee in this row is the current App user (has the same Email) OR
• The employee in this row belongs to the department that the current user wants to update OR
• The employee in this row previously belonged to the department that the current user wants to update

Example Original Expression

OR(
  [employee_Email] = USEREMAIL(),
  [employee_department_Code] =
    ANY(SELECT(parameter[parameter_DeptUpdate], [parameter_User] = USEREMAIL())),
  IN(
    [employee_id],
    SELECT(
      history[history_employee_Id],
      [history_DeptCode]
        =
        ANY(SELECT(parameter[parameter_DeptUpdate], [parameter_User] = USEREMAIL())))))

Example Expression rewritten using WITH

WITH(
  "user_department_to_update",
    ANY(SELECT(parameter[parameter_DeptUpdate], [parameter_User] = USEREMAIL())),
  "employee_ids_previously_same_department",
    SELECT(
      history[history_employee_Id],
      [history_DeptCode] = [_CONST.user_department_to_update]),
  OR(
    [employee_Email] = USEREMAIL(),
    [employee_department_Code] = [_CONST.user_department_to_update],
    IN([employee_Id], [_CONST.employee_ids_previously_same_department])))

I'm having some trouble with chart creation; I have a sheet listing all of our users as well as some general information about each of them. Three of the columns on this sheet are Yes or No columns on whether or not they have a certain product. I need to show a bar chart where there are three bars, in which each bar represents the total count of "Yes" values of one of the three columns individually. It's simple enough to count all of the "Yes" values in each column using virtual columns and Select and Count expressions, but trying to format the chart to show three bars, the total count of "Yes" in each column seems somewhat unclear. 

I am trying to build a logistics app that will be driver Facing, and would like to utilize the GeoFencing feature as well as only limit data to a specific driver when they are added to the app. 
I wanted to know if there was a way to limit information to a user up until they are assigned a task/order and when they complete that task/order for it to disappear off their list?

Sorry if this has been answered i am very very new to this program.

How do you support  an organization to build there app.? If  I build an app in my  google space , how do I send it or share it with the organization?

Is AppSheet included in Google Workspace?

you could also go for public apps ..if data is not sensitive and no sign in needed,, any number of users , 50 USD  per app.

15May22 0827 Greetings from New Zealand. What's the best to minimise deployment licensing costs? (I am thinking of building an app for 20 users.)