Hi all, trying to put together some pdf templates for an email notification workflow rule.
I keep getting errors in my expression, as I am trying to mimick an example of this sort of scenario from the help section “Reports” so the template should look something like this;
I am attempting to recreate this for my app but with small changes such as the Supplier Name being the object for sorting the data i.e. each Order shows the related Order Details for that supplier. My expressions keep causing errors in my app sheet editor but I am not sure of the issue. My own template looks something like this;
Note: the ‘Total Ordered’ column value is missing because the way I created this value in the app is by concatenating the ‘Product’ and ‘Order No’ columns and grouping the inline data with that virtual column. The Total Ordered value is then tallied using the group aggregate sum function. I am now realising that there is no way to insert that into the report at present, is there anyway around this?
Your Start formula seems to be little weird. Are you looking syntax like…
<<Start: ORDERBY(SELECT(Orders[Order No],AND([ETA]=TODAY()+1,[Order_Status]=“Ordered”)),[Supplier])>>
Thanks for the response. I have tried different syntax’s’ but everything I seem to find to solve the errors does’nt work. The columns cant be found according to the error messages. Below are some of the errors coming back from the syntax you provided;
Yes I’m pretty sure, I have checked multiple times and the chances of ALL columns input having a typo are slim to none. Do you think this is some sort of bug?
It’s triggered by a separate table called ‘Deliveries Notification’ this table stores the current date and time so once the action button is clicked the date will change to the current date + time, which triggers the email notification to send. I have done this kind of thing before and the templates weren’t much of an issue but I was only pulling information from the Order Details Tbl ,not two tables.
The reason I didnt use the Orders table directly is because there are adds/updates/changes to it too often, so I had concerns that the workflow rule would not trigger at the right time. Additionally, the app acquires the same functionality elsewhere so I though it bets to be consistent.
The app I am building is part of my job role, sharing company data outside the organisation via is not necessarily allowed. Sorry! My manager is not with me today, getting permission at the minute is not possible I’m afraid.
Sorry to jump into the middle of this. I notice that the first error is complaining of an unmatched START. This needs corrected first as it may be causing all of the other issues.
I see the first END statement, inside the table, has square brackets [ , ] around it. I think you need to remove those.
Also, I compared to similar templates I created. I placed the END statements outside of the table. In your case, if the above doesn’t resolve the error, then I would suggest adding a blank line just before the “Total Ordered” table row and try moving the END statement there - outside of the table.
For clarity, I will try changing my template to put the END inside the table and see if I start getting errors and report back here.
For my template, I moved an END statement into the table and received the error “Expression ‘End’ is invalid due to: Expression refers to undefined field”
Therefore it looks like you CANNOT have the END statement that corresponds to the START, inside of the table. You must move it to outside the table. In your case, I am assuming that the “Total Ordered” table row should NOT be included with the second START, so the END statement must be placed before that. This means you have to insert a blank line BEFORE the “Total Ordered” table row, in other words you need to separate that table into TWO tables each with a single row and a blank line in between. Then move the END statement to that blank line.
I hope I have explained clearly enough. If not, let me know.
I tried this soltuion, it worked to a point. A lot of errors have been removed but I think the main issue is the syntax of the “ORDERBY(SELECT(Orders[Supplier],AND([ETA]=TODAY()+1,[Order_Status]=“Ordered”,[Mech/Elec]=”Mechanical”)),[Supplier])”
The errors keeps coming up that this should generate a list of ref values, which should come from the key column of the referenced table
