In appsheet csv export does not include referenced columns in the output, header is showing up, but not the column values
Solved! Go to Solution.
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
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
You may be wanting more that what it's designed for
User | Count |
---|---|
43 | |
28 | |
23 | |
14 | |
14 |