I’d like to create a Bot that will add a new record from a Quote table, with its related line items, to an Orders table where the Detail column in the Orders table is a concatenation of line items including new line characters from the Quotes and its child table. Is this possible?
To create a PDF of the quote I use the following entries on an attachment template. Our Quotes are not usually very long but I’d like to include the same data (excluding the Amount Column) in a single long text column in my orders table. I know it may make more sense to link the tables, but I don’t really want to do that for many reasons. If I build this code into a Data Action, I think I may not be able to retain the new line characters which will make it very hard to read. Am I asking too much of Appsheet to do it this way?
| <<IFS([Base Amount]<>0,1)>> | <<IF(OR(ISBLANK([Basic Text]), [Basic Text]=FALSE),””,[Basic Text])>> | <<IFS([Base Amount]<>0, [Base Amount])>> |
|---|---|---|
| <<IFS([Listed Inclusions Count]>0,”Inclusions”)>> | ||
| <<Start: SELECT([Related Line Items][Line Id],[Itemise]=”Listed Inclusion”)>> <<[Qty]>> | <<[Description]>> | <<[Amount]>><> |
| <<IFS([Exclusions Count]>0,”Exclusions”)>> | ||
| <<Start: SELECT([Related Line Items][Line Id],[Itemise]=”Exclusion”)>> <<[Qty]>> | <<[Description]>> | <> |