Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Need to insert an autonumber field into my email automation

Topic Labels: Automations
Solved
Jump to Solution
4052 6
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.