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.