Email subject line issue - id's listed in subject line vs. text

AppSheet AppSheet Q&A
1

I have an email automation where I reference table fields in the subject line. When I generate the report I’m getting a short list of comma separated id’s instead of the data I’m referencing but the data expected is simple_text - no ref id’s associated.

  • The fields I’m referencing are simple text fields - no number formats, quotes, no REF’s and not calculated.
  • When I check the table for the actual data it should pull, the text is fine and as expected.
  • the vir_recv_file_name was previously formatted as NAME datatype - changed it to TEXT - no luck
  • I deleted the expression and retyped it in - no luck
  • I regenerated the table but still now luck
  • I have the same exact subject line expression in another app and it works fine. I’ve copied the exact expression from the other app into this apps subject but
  • The email and it’s corresponding attachments generate fine except the same expression is used in the file name and has the same issue.

Any help or insight would be greatly appreciated. A million thanks

Existing Expression:

Daisy_Ramirez_0-1723065873683.png
Daisy_Ramirez_0-1723065873683.png594×371 20.3 KB

<<[Division]>>-<<[vir_recv_file_name]>>-<<[vir_file_date_time]>>-NEW RECEIVING_PORTAL FILES<<USERSETTINGS(version_flag)>>

Email being received

Daisy_Ramirez_1-1723065939008.png

Table being referenced for the 2 fields

Daisy_Ramirez_2-1723066076654.png
Daisy_Ramirez_2-1723066076654.png3375×1616 882 KB

Daisy_Ramirez_3-1723066153460.png
Daisy_Ramirez_3-1723066153460.png1303×1584 432 KB

2

Possible the email is going out before the file is uploaded? Uploads occur asynchronously and occur in the background even while the user continues working with the app. after the upload completes, AppSheet goes back and puts the uploaded files name into the column. If the file is very large or just takes a long time to upload, it’s possible the app might use the column expecting the value to be there but it isn’t.

3

Thanks Steve, the issue hasn’t happened before. Any recommendations for how to repair. Is the condition to delay the email fixed where we can used it again?

4

Not sure if this helps - but the generated Subject in your screenshot, going by the hyphens (-), seems to have a file name value that is blank and a date field value that seems to have four values separated by commas.

Could it be that the spreadsheet you are visually checking is not the same spreadsheet used by the app? Maybe you are working off of a later copy of the spreadsheet with the same name? To be certain, assuming the source is Google Sheets, in the development U/I, you could navigate to Data → click on Table in question → Table Settings → Storage → scroll down to “Source Id”. It should the match the id in the Google Sheets URL.