formula problem

[Sarah_Cliff]

Hi all,

Looking for help on this issue. Created a zap to alert me of a new record in a view. When it sends the message, it garbles my field data. Dates work, but any text fields do not.

Any advice/assistance?

[Sarah_Cliff]

Here’s an example of the data.

[John_Gilmore]

can you screen shot the zapier workflow? There is a good chance I can help if I see that, as I have like a bajillion zaps and have done probably more zapier work/troubleshooting than most anybody besides their employees I feel. Like, anyone using it like I do probably should learn to code…

Have you asked Zapier? My experience has been they are prompt and helpful. But I’m a paying user of zapier; not sure if there are free tiers that don’t have support.

[Julian_Kirkness]

These look like primary key field values to me?

I am assuming here that you are trying to send values that are from Link fields (or the key field from the current record) - although these look like they contain text, they actually store a key value. In order to get the value you want, you need to add a Lookup field to your table to get the value as text from the linked table (and sometimes a Formula if you want to create the value you need from several fields.)

Feel free to get back if you have more questions.

Julian

[Terence_Tam]

Thanks Julian - this solution solves a number of other identical threads. Hats off to you!

[Tammy_Wilson]

Thanks–that was just the info I needed to fix my new Zap! :grinning: