Solved: PDF Template Question - Page 2

Ryan_Wagner · 10-31-2022 10:40 AM

Hi. I'm making my first attempt at generating a "work order" via automation...

I found a great post here that helped me setup my Google Doc template, which works perfectly, except I'm having trouble get a Ref column to show up the way I want.

When I enter my Ref column in the template, it generates a list of the related unique IDs rather than the list of previous repairs I was hoping to see:

This is the formula I used for getting the reference:

Is there a way to accomplish what I'm after?

I'm sure I'll need to provide more info....Thanks for taking a look.

WillowMobileSys

Try using this instead:

<<[Work History][...Name of Column you want...]>>

Just to explain a bit, for Ref type columns, AppSheet will use a column designated as the Label for the table to display the value. In other words, in the views, The Ref value (row key) is replaced with the value from the column set as the Row Label. But this is for display only!!!

The same replacement does not happen any where in AppSheet. You would need to specifically select the column value you want shown. The expression I provided above is a shorthand way of inserting a SELECT() expression.

View solution in original post