This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question
leeca
Bronze 5
Bronze 5
Since ‎04-14-2021
2 weeks ago

My Stats

  • 23 Posts
  • 0 Solutions
  • 11 Likes given
  • 9 Likes received

Mike89's Bio

Badges leeca Earned

View all badges

Recent Activity

CASE WHEN equivalent in AppSheet operating on a list column

03-25-2022
How to categorize a list column?For example, I have 3 rows in my table, the column type is List and column name is [Purchase Status]:1. {To Purchase, Purchase Complete}2. {Purchase Complete, Purchase Complete}3. {To Purchase, To Purchase}To further c...

How to filter a select expression in 2 columns

03-17-2022
I'm working on a HR app that displays selected rows to two groups of users: Admin and User.The approach I took was to display a slice of a table to a logged in user that either has:- [isvisibleBy]: Rows assigned to be visible to him/user (col type En...

Implement RANK() OVER (PARTITION BY ORDER BY) as virtual column

03-05-2022
Hello,Is there any way to implement the following SQL Query in AppSheet as a virtual column: RANK() OVER ( PARTITION BY [Date] ORDER BY [Created_At] ) AS Sequence

Use UNIQUEID() as REF

04-14-2021
Hello all, new to AppSheet - trying to implement the below DB Model in AppSheet: In AppSheet, I have set up the relationship / reference between Contracts and Nomination as follows (Contract is input by the user as TEXT type, and is a primary key in ...