When it comes to the workflow template, it is requirement we generate the multiple rows of table, which is usuall in the form of vertical table, i.e. the first row hold the column names.
Instead, case by case, we may need vertical table to repeat the rows out of original table where the data resides.
This is tips how to generate the vertical table within Apphsheet workflow template.
[Print selected record with its childs](https://community.appsheet.com/t/print-selected-record-with-its-childs/21184/33) Questions
Just worth trying. What s gonna happen if you change the template like this? [image] Move start end expression outside table and sandwich the whole table?
@Geovany_Kelly
@Suvrutt_Gurjar
@Lynn
7 Likes
Thank you very much @tsuji_koichi for documenting this useful tip.
1 Like
And if you want to have one page per table of each related records just insert a Page Break in the first <<End>>
the final template would look like this:
Final doc:
7 Likes
Great, yes, good point.
I do have some app with me, exactly same setting, just add page break.
Hope this will be found useful mate.
1 Like
@tsuji_koichi
with this error how to fix this… this is my workflow email error
Failed: Action not performed because 78 errors are present. Error: Workflow rule ‘New Audit’ action ‘Action 1’ Attachment template. Expression ‘[Remarks_18]’ is invalid due to: Unable to find column ‘Remarks_18’, did you mean ‘Remarks_17’?. Error: Workflow rule ‘New Audit’ action ‘Action 1’ Attachment template. Expression ‘[Remarks_20]’ is invalid due to: Unable to find column ‘Remarks_20’, did you mean ‘Remarks_21’?. Error: Workflow rule ‘New Audit’ action ‘Action 1’ Attachment template. Expression ‘[Remarks_22]’ is invalid due to: Unable to find column ‘Remarks_22’, did you mean ‘Remarks_21’?. Error: Workflow rule ‘New Audit’ action ‘Action 1’ Attachment template. Expression ‘[Remarks_24]’ is invalid due to: Unable to find column ‘Remarks_24’, did you mean ‘Remarks_21’?. Error: Workflow rule ‘New Audit’ action ‘Action 1’ Attachment template. Expression ‘[Remarks_26]’ is invalid due to: Unable to find column ‘Remarks_26’, did you mean ‘Remarks_21’?. Error: Workflow rule ‘New Audit’ action ‘Action 1’ Attachment template. Expression ‘[Remarks_28]’ is invalid due to: Unable to find column ‘Remarks_28’, did you mean ‘Remarks_21’?. Error: Workflow rule ‘New Audit’ action ‘Action 1’ Attachment template. Expression ‘[Check Set Point (22 - 24 degC)_30]’ is invalid due to: Unable to find column ‘Check Set Point (22 - 24 degC)_30’, did you mean ‘Check Set Point (22 - 24 degC)_29’?. Error: Workflow rule ‘New Audit’ action ‘Action 1’ Attachment template. Expression ‘[Remarks_31]’ is invalid due to: Unable to find column ‘Remarks_31’, did you mean ‘Remarks_21’?. Error: Workflow rule ‘New Audit’ action ‘Action 1’ Attachment template. Expression ‘[Return Air Temp. / Room Temp._32]’ is invalid due to: Unable to find column ‘Return Air Temp. / Room Temp._32’, did you mean 'Return …
Root cause of your problem should be nothing to do with the subject of this thread.
based on error message, the Appsheet is not recognizing the majority of fields name which you place on the template. Make sure you have all the fields are actually sitting on the source table.
3 Likes
