In the template we have the Job: <<[Job]>> and then 5 other columns just like that and when the report goes through they are all there, all in the Labels. Except for the Job Column. In the Data-> Columns tab, the table Job has the key and then the name, the name is the label. It is working everywhere else in the app except for the Report
Any Ideas?
If Job is a Ref column, you can fetch the label using deref, [Job].[Name] or whatever.
That didnโt work, for the Job table, JobID is the Key and Job is the Name. So would I have put [JobID].[Job] in the Job Column in the Job Table? Or in the Job column in the main table?
Please elaborate a little more on the parent and child tables and the columns involved. Or is there only one table?
The correct answer for me is [JobID].[Job]. Add that formula into your Workflow template.
Added that to the Report template and it gave me this error:
โErrorsโ: โError: Workflow rule โEmail Renewal Noticeโ action โExpiration Notificationโ Attachment template. Expression โ[JobID].[Job]โ is invalid due to: Error in expression โ[JobID].[Job]โ : Unable to find column โJobIDโ, did you mean โJobโ?. Error: Workflow rule โEmail Renewal Noticeโ action โExpiration Notificationโ Body template. Expression โ[JobID].[Job]โ is invalid due to: Error in expression โ[JobID].[Job]โ : Unable to find column โJobIDโ, did you mean โJobโ?.โ,
I got it working, instead of using the [JobID].[Job] I used [Job].[Job], which is what I think @Bellave_Jayaram was saying in his first comment but I just didnโt completely understand it.
Excellent!
User | Count |
---|---|
40 | |
36 | |
33 | |
23 | |
17 |