Hi @Shanth18 ,
Great question!
If you are wanting to include the values from your referenced table you can use an initial value dereference expression to autofill these values from the referenced table. You will need to manually add these values from the referenced table initially, but for future records you can add an initial value to the new columns and these records will autofill from the parent table. Then on CSV export your values from the referenced table information will be on this CSV download table.
EX:
Item - Parent Table
| ID | Item | Description |
| abc123 | Apples | Red Fruit |
| def456 | Grapes | Purple Fruit |
Inventory - Child Table
| ID | Item ID | Item Name | Item Description | Amount |
| czv564 | abc123 | Apples | Red Fruit | 10 |
| tyu123 | abc123 | Apples | Red Fruit | -5 |
Data Tab
ID - Key
Item ID - Ref - Item Table
Item Name - Text - Initial Value - [Item ID].[Item]
Item Description - Text - Initial Value - [Item ID].[Item Description]
More Info:
Check out this AppSheet Documentation here for more information: Dereference Expressions
Hope this helps! Let me know if you need more information.
Thanks,
Austin from AppSheet Training
LinkedIn
Twitter
