Workflow/report merge failure: I get this error buried in my log when I try to run my Report with my Template: Error: Workflow rule โViolations Printoutโ field โAttachmentโ expression โSELECT(Properties[BlitzKey])โ is invalid due to: SELECT has invalid inputs.
Error: Workflow rule โViolations Printoutโ Start expression โSELECT(Properties[BlitzKey])โ should generate a List of Ref values. Please verify that it generates a List and that the contents of the List are Ref values. Ref values should come from the โKeyโ column of the referenced table.
So, BlitzKey is the key column of the Properties table. I canโt figure out whatโs going on here? Any ideas? Iโm not getting any output. Iโm aiming for a (currently blank) email with an attachment (that is, I have no email template, only an attachment template on the report. Thanks!
In case itโs not obvious: Iโm brand new to both reports/workflows, AND templates. But I copied from Order Capture, and simplified all the way down to just the first couple fields, and still got this. I tried <<Start:Select(Properties[BlitzKey}, true, true)>> and I tried <Start:Properties> (I think that was it) โ anyway, since Iโve never gotten it working I donโt know what to try next. Thanks for any help. Sorry for length hereโฆ
In this last post you typedโฆ Select(Properties[BlitzKey}, true, true) where it should be Select(Properties[BlitzKey], true, true) but I believe that } is just a typo error in here. Correct?
Iโm a little hazy if I need to put that in brackets: <<Start:TOP([Related Violations [BlitzKey]], 3)>>
or not. It seems like brackets donโt work (Iโm a little curious as to why Appsheet would name a field with a name that actually includes brackets?)
Then use that name after your Start expression. Itโs a filtered list from those options that are related to this record. Please remember that Top only works with OrderBy and cannot be used in isolation.
OHHH! I didnโt realize that about TOP, sorry. Thank you.
So this is what I just tried: <<Start:[Related Violations [BlitzKey]]>>
And I get (buried in my Log):
"Error: Workflow rule โViolations Printoutโ field โAttachmentโ expression โ[Related Violations [BlitzKey]]โ is invalid due to: Unable to find column โRELATED VIOLATIONS [BLITZKEY]โ. Error: Workflow rule โViolations Printoutโ Start expression โ[Related Violations [BlitzKey]]โ should generate a List of Ref values. Please verify that it generates a List and that the contents of the List are Ref values. Ref values should come from the โKeyโ column of the referenced table. Error: Workflow rule โViolations Printoutโ Start expression โ[Related Violations [BlitzKey]]โ should generate a List of Ref values. Please verify that it generates a List and that the contents of the List are Ref values. Ref values should come from the โKeyโ column of the referenced table.
TOP(ORDERBY(Related Violations [BlitzKey],[OrderColumn],FALSE),3)
As Iโve said, the actual field name includes square brackets, which then end up inside other brackets: Iโm hesitant to change the field name since itโs autogenerated and Iโm not sure if itโs relied on somewhere.
This is it now:
<<Start:TOP(ORDERBY(Related Violations [BlitzKey],[PropAddress],FALSE),3)>>
It doesnโt even register a log event. Iโve tried it more than 3 times. No emails.
Just to be safe, btw, Iโm cutting & pasting that field name.
Please take a printscreen from your template.
Pretty simple:
Yes, sorry, that was just a typo.
NOte that I just added brackets around [RelatedโฆBlitzKey], Iโve tried with & without
Just to be CLEAR: Iโve been assuming << and >> is in fact 2 โless thansโ and 2 โgreater thansโ, not some other kind of secret code Iโm supposed to be entering in some other manner?
Also, thanks so much for taking this time.
Also to be clear: I assumed your โOrderColumnโ was to be swapped for a real column?
Your expressions seems to be okay. Try to add a virtual column. First add an app formula like [Related Violations [BlitzKey]] and see if it gives you the list.
hmm. Well, you gave me the idea of going to the table and โview dataโ after I added the column. That lead me to believe that the security filter, and/or the hidden status of the key field, was killing me. I changed both those things, reloaded/waited for 5 minutes, and my junky little report is sort of working. Serious progress. I also created another virtual column, but I donโt think that would have done anything (since I didnโt use it): would it have?
Your list was probably just empty and thatโs why it didnโt bring you anything.
Question: I have a security filter based on a usersetting. Can I get it to ignore that somehow? Should I create a slice that doesnโt include the filter, or vice versa, have the app work off filtered slice and use the full table for the report? I think that security filter was what was killing me. Wow, that was hours and hours.
Have you read this articleโฆ help.appsheet.com - Start Expressions in Embedded Templates Start Expressions in Embedded Templates help.appsheet.com
I just skimmed it. I think Iโm doing it right (now: I wasnโt at first): Iโm using <<Start:[Related Violations [BlitzKey]]>>
Glad you find the correct format whereas the SELECT can be used as well.
Wow, this is tenacious. This is the code, currently, in my app, though Iโve tried dozens of things:
Thereโs a header too. When I press โRunโ (this is a Report: any reason it should be a Workflow?), I get ALL the records (it ignores the TOP) and no field values (PropAddress is non-blank for every record).
As an aside: I seem to have to reload Appsheet for it to read an edited template, is that normal?
What is your virtual column name in the related table? You can use that one for it.
The (automatically named) VC is โRelated Violations [BlitzKey]โ
User | Count |
---|---|
40 | |
34 | |
28 | |
23 | |
17 |