Hi,
I am trying to create a pdf for work order.
Is it possible in pdf format to get all line items with common foreign key to display together
Yes if by foreign key, you mean reference column in the child table, yes you can do so.
It sounds that you are trying to create a PDF of work orders with line items (Child table of work order table) for that work order.
If so, please take a look at the sample app below and the Order update and customer update bots in that sample app. They have PDF generation of Orders table with child table of “Order details”
3 Likes
Hello @Boa_Casa , yes, you can show all items related to a foreign key, be it an order, an item, a client, etc.
Check out these pages for more info:
https://help.appsheet.com/en/articles/961746-template-start-expressions
2 Likes
Hi,
Thank you so much for the input, but I am facing an issue I have used select function to pull value from one of the tables as per below screenshot attached but instead of pulling value its only displaying the formula in pdf output, any where I am going wrong?
Your SELECT expression requires the use of the “<<” and “>>” as well just as all the other values you’re pulling, that’s how appsheet knows which part of your template to read as an expression and which ones as text.
4 Likes
Hi,
Thanks for this. Was able to resolve the issue. Though had another query which I am unable to get the answer to.
Say Quote table is my Parent table, Room is my child table and Curtain is my Grand child table.
I am using select option to get data from curtain to quote table via room table and I have written a select function but a getting an invalid expression. If you could help in knowing what is going wrong.
SELECT(Curtain M[Width of door/window (inches)],[Room ID].[Room id]= [_THISROW]. [Quote ID].[Room id])