Hello, I have an issue that need your help. I have 3 tables which is referenced respectively. But the child table( table 3 ) is not generated to show on template during generate to pdf . Pls assist to advise
How if i want to put ref column in the middle of page? Eg: 1st row : parent item, 2nd row child item, then 3rd row parent item. Pls guide me how to use start end expression
Hello sir, thanks a lot for this video. But, may i ask : 1. How to show specific column (child as Ref) to doc template 2. My child table acctually has 9 column, can i choose all (many tutorial i saw about child to pdf max only 5 column) Thank you
sir could you tell me how to make a button for triggering the pdf for my stored data in appsheet. please i am trying from last 7 days nothing happened.
Hi Would you try please to do and explain your steps slow and one by one instead of jumping with the cursor without letting us got the steps !! The idea of the video always is clear so our challenges with your good ideas is just running behind your cursor !!!! Try to take it easy Thanks
Hi, The idea here is to show only how to add the ref_rows in pdf. If you already have an idea with ref_rows and pdf automation this will be easy for you to understand. To summarize. *Add ref_rows in your table (a virtual coloumn) *Create PDF Automation *Use this start and end expression in pdf () Fell free to ask if you have any difficulties to execute this toturial. Take it easy 😁
Hello brother, Can you advise since I have an Item code ( key code) in Table A and have multiples locations in Table B which I want to export both 2 table to one sheet and export to PDF, which called and " Export Summary _Google WorkSheet " and "Print Cargo Receive Receipt _PDF" . Example, Table A item code A0001 Total qty Receive =10 . ( Total qty Receive is from sum of Location B20 and B 21 ) Table B item code A000 1 Location B-20 = 5 item code A000 1 Location B-21 = 5 the Purpose is to execute these 2 tables to show on another table sheet called " Summary Receive " and Print out pdf called " Cargo Receive Receipt " Thanks for kindly help.
Hi, In your summary table you can create 2 virtual coloumn and use ref_rows() Ref_rows("Table A","Item Code") Ref_rows("Table B","Item Code") Dont forget to add this 2 virtual coloumn in Summary Table Detail View. Then in PDF Automation you can create a table for each accordingly
If I want each record on a seperate page within the PDF, how would I implement?
Thank you for sharing yr exp. look forward for more vedios...
You did't explain how to create the second action to reset the trigger for printing
Is it possible to add the button on the table, in order to do less clicks
Thanks for you tutorial, really helped
Hello, I have an issue that need your help.
I have 3 tables which is referenced respectively. But the child table( table 3 ) is not generated to show on template during generate to pdf .
Pls assist to advise
How if i want to put ref column in the middle of page?
Eg: 1st row : parent item,
2nd row child item,
then 3rd row parent item.
Pls guide me how to use start end expression
Hello sir, thanks a lot for this video.
But, may i ask :
1. How to show specific column (child as Ref) to doc template
2. My child table acctually has 9 column, can i choose all (many tutorial i saw about child to pdf max only 5 column)
Thank you
sir could you tell me how to make a button for triggering the pdf for my stored data in appsheet. please i am trying from last 7 days nothing happened.
Test your automation bot if all ok
Hi
Would you try please to do and explain your steps slow and one by one instead of jumping with the cursor without letting us got the steps !!
The idea of the video always is clear so our challenges with your good ideas is just running behind your cursor !!!!
Try to take it easy
Thanks
Hi,
The idea here is to show only how to add the ref_rows in pdf. If you already have an idea with ref_rows and pdf automation this will be easy for you to understand. To summarize.
*Add ref_rows in your table (a virtual coloumn)
*Create PDF Automation
*Use this start and end expression in pdf ()
Fell free to ask if you have any difficulties to execute this toturial. Take it easy 😁
@@JoeTayactac Thanks
@@JoeTayactac But it will be more helpful sir if you make a complete video one by one step./ please sir. request.
Hello brother, Can you advise since I have an Item code ( key code) in Table A and have multiples locations in Table B which I want to export both 2 table to one sheet and export to PDF, which called and " Export Summary _Google WorkSheet " and "Print Cargo Receive Receipt _PDF" .
Example,
Table A
item code A0001 Total qty Receive =10 . ( Total qty Receive is from sum of Location B20 and B 21 )
Table B
item code A000 1 Location B-20 = 5
item code A000 1 Location B-21 = 5
the Purpose is to execute these 2 tables to show on another table sheet called " Summary Receive " and Print out pdf called " Cargo Receive Receipt "
Thanks for kindly help.
Hi,
In your summary table you can create 2 virtual coloumn and use ref_rows()
Ref_rows("Table A","Item Code")
Ref_rows("Table B","Item Code")
Dont forget to add this 2 virtual coloumn in Summary Table Detail View. Then in PDF Automation you can create a table for each accordingly
@@JoeTayactac thanks brother and will try . And will ask you more for help.
Thanks kuya
Hi Joe,
How many users can use Appsheet for free?
I believed 10 as long as you are not deploying the app