Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
We would like an app to populate an answer in a field if its blank and meets criteria. We have tried adding two expressions to the script but neither works:
"e_mail",if(e_mail = "-", 'No email', 'Has email'),
or
"tency_end_dt", if(tency_end_dt = null, 'Current Tenancy', 'Previous Tenancy'),
Any suggestions/advice?
Much appreciated.
Chris
Most often you didn't really want to check if a field(value) is NULL (the '-' within the table-charts is only a replace-char for NULL and could be changed within the tab presentations on the bottom left) else you want check if no (valid) value is available. With len(trim()) you caught not only NULL else empty strings (for example this: = '' is not NULL) and not printable chars like leading spaces or many types of special chars. Very good explanations could you find here:
- Marcus