Hi,
I'm looking at have a virtual column in my appointments table to remind the user to get certain information when attending the appointment.
The idea is that if the customer that the appointment belongs to doesn't have a mobile phone number saved, my Todo entry is automatically populated with "Mobile". The same for Email and a few others.
I've done this with IFS() currently...
App Formula for Todo Column;
IFS(
ISBLANK([CustID].[Mobile]), "Mobile. ",
ISBLANK([CustID].[Email]), "Email. ",
ISBLANK([CustID].[Related Photos]), "Photo. ",
)
...but of course this will only do one at a time. I'm stumped for a way of going through each clause so that at the end of it my Todo entry is a list of multiple strings ("Mobile. ", "Email. ", "Photo. ").
thank you!
Solved! Go to Solution.
LIST( IFS( xxx , "Mobile") , IFS( yyy , "Email") , ... ) - LIST("")
LIST( IFS( xxx , "Mobile") , IFS( yyy , "Email") , ... ) - LIST("")
Thank you!
what is the purpose of - LIST("")?
Remove any blank values from the list
https://help.appsheet.com/en/articles/4575802-list-subtraction
User | Count |
---|---|
39 | |
35 | |
29 | |
23 | |
18 |