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.
Aug 02, 2023 07:44 PM
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!
Solved! Go to Solution.
Aug 11, 2023 07:43 AM
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.
Aug 02, 2023 08:31 PM
Hm, I just tried this and it seemed to work fine for me:
Sorry I can't help, but perhaps you can use it as a comparison thing?
Link to base
Aug 03, 2023 04:06 PM
Aug 05, 2023 07:20 AM - edited Aug 05, 2023 07:20 AM
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
Aug 07, 2023 12:48 PM
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.
Aug 11, 2023 06:30 AM
Hm, I don't think that should make a difference actually, but whatever works!
Aug 11, 2023 07:43 AM
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.