Workflow returning blank REF

[Jonathon]

Hey team,

I’m having an odd issue with a workflow. I am firing a daily report across all projects. (ForEachRowInTable, on projects table).

For each project, it selects some amount of child records and prints them - this works fine.

Recently I updated this child table to have a grandchild table which allows for additional information to be captured regarding one of the original fields.

Now, the old report prints out the UNIQUEID() of the grandchild record instead of the grandchild name or label which is contained in the new grandchild table, as is expected as that column has been converted to a REF. To update the table, It should be as simple as the below:

The problem is, when the workflow fires I am returning blank values where the grandchild label should be. Within the app, the [grandchildREF].[name] formula works as expected, and I can return the label in a virtual column within the child table. I have tried doing this, and then including the virtual column in the workflow template, and I get the same blank result.

I have done similar things before, with user() tables to return usernames… I can’t understand why this is proving so difficult? Any thoughts?

[Jonathon · Accepted solution]

I don’t know why but it seems as soon as I reach out for support on the forums it kicks my mind into gear and I find the problem myself…

I’ll leave the post up as some future unfortunate soul may run into the same problem and do a search…

---

SOLUTION

I was being silly and forgot to include a security filter for the grandchild table, which allowed the app owners account through:

OR(
   USEREMAIL()="appsheet_acct@company.com",
   [project_id]=USERSETTINGS(project_id)
)