Null Field Values: Handling Vendor API Variations
Samantha Hawkins
Our webforms pulled product interest data from various listing services. Each vendor’s API sent three separate dropdown values for product interest, which were combined into one field in Salesforce using a formula inside a flow.
Different APIs handled empty or unselected dropdowns inconsistently. Some sent blanks, others sent the string "None" or "--None--". When these values got aggregated, reports showed confusing and cluttered data.
What I Did:
🌸 Reviewed the data and traced back the flow logic to see what was going on
🌼 Updated the existing formula to treat blanks and all variations of “None” as truly empty values
🌿 Improved report quality and user experience
Subscribe to my newsletter
Read articles from Samantha Hawkins directly inside your inbox. Subscribe to the newsletter, and don't miss out.
Written by