Generating file with task but data from virtual column is missing

[Benny_mk]

So I have a virtual column that I would like to print out together with the rest of the data, but whenever I try generating a file , the data in the virtual column is not recorded in the file.

I suspect that the data in the virtual column is not recorded in the spreadsheet before the file is generated.

Any suggestion how to go about with it?

[Marc_Dillon]

Virtual columns are NEVER recorded in the spreadsheet. What is the expression that you're using in the VC? Does it depend on other records that may not have been created/edited before the Bot was triggered?

[Benny_mk]

oh right! the expression is REF_ROWS("Products", "Invoice No.")

[Marc_Dillon]

See section "Sending Email Only After Adding a Parent Record and All of Its Children " here:

https://help.appsheet.com/en/articles/961707-workflow