csv template with header

AppSheet AppSheet Q&A
1

Hi,@AleksiAlkio i have an order capture where there are 2 tables, ORDER TABLE and ORDER DETAIL. I need to create a csv template with header for the related file. I inserted this string

<<Start: SELECT(Order Detail [Id Detail], [Id Order] = [_THISROW].[Id Order])>> Cod Art.;Description;Price;Qta;Note; “<<[Cod Art.]>>”;“<<[Description]>>”;“<<[Price]>>”;“<<[Qta]>>”;“<<[Note]>>”; <><<Start: SELECT(Order Detail [Id Detail], [Id Order] = [_THISROW].[Id Order])>> Cod Art.;Description;Price;Qta;Note; “<<[Cod Art.]>>”;“<<[Description]>>”;“<<[Price]>>”;“<<[Qta]>>”;“<<[Note]>>”; <>

But if i have 2 or more strings, the csv created whit more COD ART.;DESCRIPTION;PRICE;QTA;NOT like that

Screenshot 2025-05-13 alle 08.03.10.png
Screenshot 2025-05-13 alle 08.03.10.png1224×346 52.5 KB

2

SOLVED

The correct string is this

Cod Art.;Description;Price;Qta;Note; (is need to put the HEADER at first

<<Start: SELECT(Order Detail [Id Detail], [Id Order] = [_THISROW].[Id Order])>> Cod Art.;Description;Price;Qta;Note; “<<[Cod Art.]>>”;“<<[Description]>>”;“<<[Price]>>”;“<<[Qta]>>”;“<<[Note]>>”; <><<Start: SELECT(Order Detail [Id Detail], [Id Order] = [_THISROW].[Id Order])>> “<<[Cod Art.]>>”;“<<[Description]>>”;“<<[Price]>>”;“<<[Qta]>>”;“<<[Note]>>”; <>

1 Like