This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Find answers, ask questions, and share expertise about Alteryx Designer.
General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!
In continuation to my earlier post about using analytic app, I am attaching the workflow that I am trying to build and looking for some help around it. All I am trying to do is connect to Salesforce input and bring in the fields from contact table. Adding a formula tool by creating a new column as REP_CRD and assigning a condition if CRD is null then pick CRD_1 if not CRD. Now user should get a prompt window to enter a CRD value and that should look to see if that value exists in REP_CRD column and return yes or no. It would really be great if someone could provide help with this. Thank you in advance
The output of the validation in the Message tool will only be visible in the console output of the workflow. If you'd like to render this as an output of an analytical app for the user to see, you can do the following
Link the Text Box with the filter instead - this will allow the user to filter on the CRD value they are looking for
Count the number of records matching the filter using the Count Records tool
Use the formula to generate a dynamic response based on the count - positive if the count is greater than 0, and negative if 0
Report Text tool will allow you to use this value to build out a dynamic message which will then get rendered by the Render tool for the user