I want to create a workflow that will create an updated job list for the construction company I work for. Currently if I set up a new job and add it to the job list that is in a spreadsheet after I set up 3 to 4 jobs I will print a new copy for a few people in the office. I have been trying to streamline this by using Appsheet. I’m having an issue with the expression though. I have a column for these: Job #, Job Name, and Customer. Is there a way to print the latest 50 jobs on that list or so? I haven’t decided on the best way for the workflow but possibly create a workflow that will email out a pdf with the latest 50 jobs on it. Could I get help on the expression please?
@Kierris
Assuming that you have Date/Datetime column present in your table that you can sort your table data, you can create a Workflow template with a START expression like this:
| Column1_Name | Column2_Name | Column3_Name |
|---|---|---|
<<Start: TOP(ORDERBY(JobsTableName[KeyColumn],[DateColumn],TRUE),50)>><<[Column1]>> |
<<[Column2]>> |
<<[Column3]>><<End>> |
2 Likes
Thank you!!
You’re welcome.