Help

Re: Need to insert an autonumber field into my email automation

Solved
Jump to Solution
2571 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Carol_Poole
5 - Automation Enthusiast
5 - Automation Enthusiast

I have a field called ID, and it's an autonumber field.  I cannot get it to display in my email.  I've tried creating a formula field with it, too, with some prepended text and tried adding &"", too, which was suggested somewhere.  I can add the Airtable record ID with no problem and other formula fields and have them included in the text of the email.  But anything I do with my ID field will not show up in the email.  The test data does have an ID in the ID field and a value in the ID Text formula field.  Any help will be greatly appreciated!

1 Solution

Accepted Solutions
Carol_Poole
5 - Automation Enthusiast
5 - Automation Enthusiast

SOLVED:  The problem was that one CANNOT test with GENERATE a PREVIEW of the contents of an autonumber field contained in the automated email.  It doesn't retrieve that value for some reason.  Once I made up a dummy record and ran the Test Automation that sends an actual email to someone, I saw that the value appears in the delivered email.

See Solution in Thread

6 Replies 6

Hm, I just tried this and it seemed to work fine for me:

Screenshot 2023-08-03 at 11.30.45 AM.png

Sorry I can't help, but perhaps you can use it as a comparison thing?
Link to base

Carol_Poole
5 - Automation Enthusiast
5 - Automation Enthusiast

Thanks for responding.  I see that your message contained the data (1) for that field.  My value won't show up in the message.  I'll keep looking!

 

 

Roger that, best of luck!  Happy to take a look at it for you if you'd like, just DM me an invite to your base

Oh, I went back to this today and see that the difference is that your auto-number name field is the primary field  and mine isn't.  

Hm, I don't think that should make a difference actually, but whatever works!

Carol_Poole
5 - Automation Enthusiast
5 - Automation Enthusiast

SOLVED:  The problem was that one CANNOT test with GENERATE a PREVIEW of the contents of an autonumber field contained in the automated email.  It doesn't retrieve that value for some reason.  Once I made up a dummy record and ran the Test Automation that sends an actual email to someone, I saw that the value appears in the delivered email.