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.
Please could someone advise if AppSheet has an if this, then that, else
do nothing expression...?IFS() is designed to produce a blank result
when it evaluates to false.When I save a row in another table called
surveys, an action there fires that incr...
I'm using substitute to strip enumlists that have this format...
AAA-BBB-CCC-020A ...down to the remaining number + letter like this...
020A Is it possible to remove the leading zero, and not affect the zero
on the number 20...? 20A Thanks in advance...
I have an ENUMLIST [assets] column that produces lists of 4 or more
items that looks like:AAA-BBB-CCC-022A, AAA-BBB-CCC-022B,
AAA-BBB-CCC-022C, AAA-BBB-CCC-023AI'd like an expression for another
column, [asset_checker], to look at the result of [asse...
I have multiple companies doing surveys that populate a surveys table.I
have a usertable that has three columns, email, company, role.The role
column has two role types, admin and surveyorI'd like admin to see all
records, and surveyor to only see re...
I'd like to see the seconds in my expression result so that I can sort
my column with more granularity.I'm using a DateTime type column with
the following initial value expression:TEXT(UTCNOW(),"DD-MMM-YY
HH:MM:SS")This is what I get:Is it possible t...
Oops... I found it... There was trouble between the chair and my
keyboard...!Thinking slightly differently about the scenario, and using
IF() properly solved it... IF( ISNOTBLANK[results_column],
(results_column],
[do_the_thing_that_gets_the_result...
Thanks @AleksiAlkio ... I'm sorry, I may have confused the issue.My goal
is to keep only the 4 right-most characters from the long string, and
then remove the leading zeros... The left part of the string is not
important.Here are three sample strings...
Many thanks @romulo_torres ... This looks very promising... I've tried
running it and I'm getting an error which I don't understand...MID
function is used incorrectlyPlease could you advise...?
