Hello I’m very new with Appsheet. Rightnow I’m trying to use Appsheet Data to create PDF for month installment table with Merged cell. I have a data set as below
| No. | Product Name |
|---|---|
| 1 | Price |
| 2 | Down % |
| 3 | Down Amount |
| 4 | 18 Month |
| 5 | 24 Month |
| 6 | 30 Month |
| 7 | 36 Month |
| 8 | 42 Month |
| 9 | 48 Month |
I’m trying to create an installment by using Automation. The formula generate by the system is as below.
| Product Name | Down % | Down Amount | 18 Month | 24 Month | 30 Month | 36 Month | 42 Month | 48 Month |
|---|---|---|---|---|---|---|---|---|
| <<Start : Related Data_Installments]>><<[Product Name]>> | <<[Down %]>> | <<[Down Amount]>> | <<[18 Month]>> | <<[24 Month]>> | <<[30 Month]>> | <<[36 Month]>> | <<[42 Month]>> | <<[48 Month]>><> |
The PDF Generate by the formula is as below.
| Product Name | Price | Down % | Down Amount | 18 Month | 24 Month | 30 Month | 36 Month | 42 Month | 48 Month |
|---|---|---|---|---|---|---|---|---|---|
| A | 100,000.00 | 10% | 10,000.00 | 5,000.00 | 3,750.00 | 3,000.00 | 2,500.00 | 2,142.86 | 1,875.00 |
| A | 100,000.00 | 15% | 15,000.00 | 4,722.22 | 3,541.67 | 2,833.33 | 2,361.11 | 2,023.81 | 1,770.83 |
| A | 100,000.00 | 20% | 20,000.00 | 4,444.44 | 3,333.33 | 2,666.67 | 2,222.22 | 1,904.76 | 1,666.67 |
| A | 100,000.00 | 25% | 25,000.00 | 4,166.67 | 3,125.00 | 2,500.00 | 2,083.33 | 1,785.71 | 1,562.50 |
| B | 200,000.00 | 10% | 20,000.00 | 10,000.00 | 7,500.00 | 6,000.00 | 5,000.00 | 4,285.71 | 3,750.00 |
| B | 200,000.00 | 15% | 30,000.00 | 9,444.44 | 7,083.33 | 5,666.67 | 4,722.22 | 4,047.62 | 3,541.67 |
| B | 200,000.00 | 20% | 40,000.00 | 8,888.89 | 6,666.67 | 5,333.33 | 4,444.44 | 3,809.52 | 3,333.33 |
| B | 200,000.00 | 25% | 50,000.00 | 8,333.33 | 6,250.00 | 5,000.00 | 4,166.67 | 3,571.43 | 3,125.00 |
How could I generate the PDF with Merged cell for “Product Name” and “Price” as below.
I hope somebody could help me with this project
Kennie923