AppSheet, Google

From rbachwiki
Revision as of 15:18, 3 December 2024 by Bacchas (talk | contribs) (Created page with "== Check if input is greater than 2 char and contains a space == AND((LEN([_THIS]) > 2), CONTAINS([_THIS], " ")) == Or, And, In, Not, If== OR(USERSETTINGS("Singer")="Anita L", USERSETTINGS("Singer")="Anita L.") AND(ISBLANK(USERSETTINGS("Singer")), IN("Karaoke",ActiveSession[Session])) IN("Karaoke",ActiveSession[Session]) NOT(USERSETTINGS("Singer")="R Bas") IF(IN(Context("View"),List("JOIN QUEUE")),"Submit Song","Save") upper(CONCATENATE("#",SUBSTITUTE(uppe...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Check if input is greater than 2 char and contains a space

AND((LEN([_THIS]) > 2), CONTAINS([_THIS], " "))

Or, And, In, Not, If

OR(USERSETTINGS("Singer")="Anita L", USERSETTINGS("Singer")="Anita L.")
AND(ISBLANK(USERSETTINGS("Singer")), IN("Karaoke",ActiveSession[Session]))
IN("Karaoke",ActiveSession[Session])
NOT(USERSETTINGS("Singer")="R Bas")
IF(IN(Context("View"),List("JOIN QUEUE")),"Submit Song","Save")
upper(CONCATENATE("#",SUBSTITUTE(upper([Name]), " ", "")))