Troubleshooting Formula for UX/UI Staff Role Identification | Clay

Troubleshooting Formula for UX/UI Staff Role Identification

need some help , I am trying to use the formula for the following; give me a sentence based on the answer.

If only 1 role, sentence should be "I noticed {NAME} is the only staff member involved in UX/UI
If none, sentence is "I browsed Linkedin and didn't see any staff members for UX/UI, I guess you're using contractors?"
If more than 1 role, sentence should be "I saw on Linkedin you had an internal Ux/Ui team".

this is the formula I am using ; {{/Find Contacts at Company}}.includes("No Profile Found") ? "I browsed LinkedIn and didn't see any staff members for UX/UI, I guess you're using contractors." : {{/Find Contacts at Company}}.includes("Found 1 Person") ? "I noticed " + {{/First Name - People}} + " is the only staff member involved in UX/UI." : "I saw on LinkedIn you had an internal UX/UI team." but every output is giving the same "I saw on LinkedIn you had an internal UX/UI team"

15 comments

Channeled
APP
·
·
To help troubleshoot your formula, you'll need to verify a few things: 1. Make sure your "Find Contacts at Company" enrichment is properly configured and returning the correct data. 2. Check if the conditions in your formula are being evaluated correctly by: • Breaking down the formula into smaller parts • Testing each condition separately • Verifying the data format returned by the enrichmentYou can use Clay's AI formula feature to help build and test your conditions: 1. Select "Ask question about items with AI" from the column options 2. Test each condition separately to ensure the data is being evaluated correctly 3. Verify the output matches your expected resultsIf you continue having issues, you may want to create separate columns to test each condition individually to identify where the logic might be failing. Sources: AI Formulas + Conditional Runs [Clay 101] - Clay University AI Formulas + Conditional Runs [Automated Inbound] - Clay University
Fatima G.
·
·
this is what find contacts at company is returning
Channeled
APP
·
·
To troubleshoot your formula when getting unexpected results, here are the key steps: 1. Break down your formula into smaller parts and test each condition separately to identify where the logic might be failing. 2. Use Clay's AI formula feature to help test your conditions: • Select "Ask question about items with AI" from the column options • Test each condition individually • Verify the output matches your expected results 3. Consider creating separate columns to test each condition individually, which can help pinpoint where the logic might be breaking down.Remember, it's normal if the AI doesn't give exactly what you're looking for on the first try. You can iterate on your formula, adjust the wording, or modify the generated code until you get the desired results. Sources: AI Formulas + Conditional Runs [Automated Inbound] - Clay University AI Formulas + Conditional Runs [Clay 101] - Clay University
Channeled
APP
·
·
Looks like you're still looking for help. We're escalating this over to our support team and someone should be in touch soon. In the meantime, feel free to include any other information that may be helpful in solving your issue!
Muhammad S.
·
·
{{/Find Contacts at Company}}.includes("No Profile Found") This wouldnt work
Muhammad S.
·
·
thats why you are getting same output
Muhammad S.
·
·
your formula is not detecting these values
Muhammad S.
·
·
count the number of items in the array and that would give you how many people were found
Muhammad S.
·
·
use that number to control your formula
Fatima G.
·
·
when i write the formula the "find contacts in company" doesn't show me the outputs that I am seeing in the columns . maybe that's the issue? like say the output for the first row is "1 person found" and second row is "7 person found" instead of showing me the exact value its showing me like this 1 row 1 , value = 1 , row 2 , value = 7 .
Muhammad S.
·
·
{{Find Contacts at Company}}?.people?.length
use this formula to check how many people were found by find contacts at company integration
Muhammad S.
·
·
then you can use that number to control your personalzied line
Fatima G.
·
·
Thank you , i used that.
Stefano
·
·
Hi Fatima, were you able to resolve your issue? I saw Muhammad kindly gave you some instructions that seem to be correct. Let me know if your issue is solved. if not I will be happy to help troubleshoot! (Thank you Muhammad for your help!)
Channeled
APP
·
·
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.