Hello Community: I will appreciate your help with the next problem. I have problems with the scheduled report of one app.I have: 1ยบ The โValesโ table 2ยบ The โDetalle Valesโ table that contains the articles and assemblies that make up each record of the โValesโ table 3ยบ The โDetalle Ensamblesโ table that contains the articles that make up the assemblies of the โDetalle Valesโ table 4ยบ The โEntregasโ table that contains the signature of the person who receives the articles and assemblies of each record of โValesโ table.
I cant get the scheduled report to show, for specific day, every record of โValesโ table:
(1) the related records of โDetalle Valesโ table, (2) the records of โDetalle Ensamblesโ related to every assembly of the โDetalle Valesโ table, and (3) the record of โEntregasโ table related with the record of the โValesโ table.
Could you guide me how to solve this problem? I read the article https://help.appsheet.com/behavior/workflow-sending-email/template-start-expressions but I have not been enough. Thank you.
Rafael
@SmartD It sounds like youโll need to use nested template expressions. If you have TABLE1 referenced by TABLE2, and TABLE2 referenced by TABLE3, then you can do something like this:
<<Start:[Related TABLE2 By REFCOLUMN2]>>
Some column from table2: <<[Some column from Table 2]>>
<<Start:[Related TABLE3 By REFCOLUMN3]>>
Some column from table3: <<[Some column from Table 3]>>
<> <>
@tony Thanks for your answer. I have tried but it doesnโt workโฆ Can you review the next image.
@SmartD Nothing stands out to me, but I could be wrong. Are you seeing any errors (e.g. in your audit log)? help.appsheet.com - Troubleshooting Workflow Emails Troubleshooting Workflow Emails help.appsheet.com
Can you help me with this problem?
User | Count |
---|---|
35 | |
35 | |
27 | |
23 | |
18 |