AppSheet, Google
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...")
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]), " ", "")))