If statement pulldata/appearance logic

213
2
Jump to solution
02-22-2024 11:40 AM
ChristinaMcCullough1
New Contributor II

I am having trouble with an if statement logic.  I am not sure this is possible.  If an email is present, fill in the email using a pulldata calculation.  If there is no email, users need to search for an email from a different source layer.   

if(string-length(${email})<1,'perform a pulldata calculation','perform a search appearance from a different layer'))

We are using the app and not the browser version.

0 Kudos
1 Solution

Accepted Solutions
ChristinaMcCullough1
New Contributor II

This worked.  Thank you.  I added a search appearance calculation to the survey. The result displays in the drop down.  A user will have to accept the new value.  Is there is a way to populate the field without clicking on a selection?

View solution in original post

2 Replies
abureaux
MVP Regular Contributor

search() goes into the appearance field. Your pulldata() will be a calculate. You can have a field that tries to pull an email, test to see if it did pull an email, and then dynamically show/hide the search() text box based on the presence/absence of an email.

0 Kudos
ChristinaMcCullough1
New Contributor II

This worked.  Thank you.  I added a search appearance calculation to the survey. The result displays in the drop down.  A user will have to accept the new value.  Is there is a way to populate the field without clicking on a selection?