Hello
New day , new problem, and perhaps new solution?
In my apps, i try to create documents and save them on g-drive.
With my first โbehaviour/worflowโ no problem with the export of datas from a table.
With the second which may send a list of datas from another table if i use the generated document template, Test button is ok, and i can generate manually , but this document is only for one row, and i need to list the details for ech [numctrl] value.
In my table i have different rows with a same id [numctrl] i put this [numctrl] as key.
Here the errorโs message, the button test ok, but impossible to send the document at the end,
Failed: Action not performed because 2 errors are present.
Error: Workflow rule โrapport_qual 2โ action โdoc_ra_qualโ Body template. Start expression โ[Numctrl]โ should generate a List of Ref values. Please verify that it generates a List and that the contents of the List are Ref values. Ref values should come from the โKeyโ column of the referenced table.
Error: The document body is empty.
I think the second error dues to the first one, but I donโt understand for the problem of the list in the first error.
After a long reflexion and looked in the faq, itโs like design of ยซdetail ordersยป.
So, I taught to change and to get the informations using relation: starting from a control closed with the value [Numctrl] as single reference, then
i put my value [Numctrl] as a key in the first table ยซ Prepctrl ยป where i plan my control,
i put the value[Numctrl] as a Ref (joined) with the table ยซ Prepctrl ยป in my second table ยซpointctrlยป,
i put the value[Numctrl] as a Ref (joined) with the table ยซ Prepctrl ยป in my third table ยซsignctrlยป.
For the 3 tables, the columns [Numctrl] are Keys.
For the table ยซ Prepctrl ยป the column is text type, for the two others, ยซ Ref ยป
I came back to my workflows, create a new template for my document, it seems allright, I test the workflow creation ( button test) and it create a document ( with the columns of my table ยซ signctrl ยป).
I put the result of a masked column coming from ยซ signctrl ยป , in my document itโs send another documentโฆperfect
I change in my template using the principes of the ยซ OrderDetailTable Templateยป ( Cascade Fine Fruits), and itโs goes wrongโฆ
Failed: Action not performed because 2 errors are present. Error: Workflow rule โrapport_qual 3โ action โdoc_ra_qualโ Body template. Start expression โ[Numctrl]โ should generate a List of Ref values. Please verify that it generates a List and that the contents of the List are Ref values. Ref values should come from the โKeyโ column of the referenced table. Error: The document body is empty.
3 days to turn around the templateโฆfaq and community, witout result.
i have a single [numctrl] in ยซ prepctrl ยป & ยซ signctrl ยป ( only one control can exist with this ID and of course only one control can be signed .
But in my table ยซ pointctrl ยป, for each control i can have 1 to x [numctrl] rows
Whatโs the matter, and what must be change to get a list in my document?
Thanks to anyone who understand more than meโฆโฆand could help me
( Sorry for poor english language)
Please post a screenshot of the template.
Please also post a screenshot of the column list (from Data >> Columns in the app editor) for the table the template uses that includes at least the key column.
Hello thanks for the answer
here in this first part the different view until to get result if i try to combinate in a unique table the 3 others
in this second part the second attempt with the 3 tables connected
Perhaps it will be less complex to understand my problem with a view ans screenshots
Thank you for all the screenshots! Very helpful!
The problem is exactly what the error says: โStart expression โ[Numctrl]โ should generate a List of Ref values. Please verify that it generates a List and that the contents of the List are Ref values. Ref values should come from the โKeyโ column of the referenced table.โ
Numctrl is correctly a Ref, but itโs not a list of Ref. A <<Start>>
tag starts the template to present each item in a list of items. The <<Start>>
expression provides the list of items to present. Even if you only want to present one item, that one item must be presented as a list: a list with only one item. If your intent is, in fact, to present only a single item, change this:
<<Start:[Numctrl]>>
to this:
<<Start:LIST([Numctrl])>>
If your intent is to instead present all rows in the regroupement_controles table, use this <<Start>>
tag:
<<Start:regroupement_controles[Numctrl]>>
Hello thanks for the help and the time you spend with me.
I tried friday with from my test button, and it created a document for / from one of my rows registred ( good thing), but today when i came back to the job, i saw a new problem: in my first table where i prepare the control, the โrefโ , the โcontrolโs numberโ, which was calculated from 3 others columnsโฆ missing. As soon as my Numctrlโs column become a Key, no more formulaโฆ
and so, if more numctrlโฆno more possiblity to check new points in the control, not abble to sign the controlโฆand create a document for the customer.
the warning message was:
I put the formula in the suggested value [Date]&"~"&[Contrรดleur]&"~"&[Site]=>>
Another and different warning message=>
If I put the type " List"as type => warning message
Well, must i create a virtual column to have my Numctrl from a formula (and of course is it possible to put the key on a virtual column) , or more exactly from a sugested value because i donโt see why It ยซ should generate a list of values ยป, itโs just an item to agregate a ref , quickly identifiable, by the controler, and used in others tables.
The idea to store the Numctrl was to have a value in my table and a possibility to extract directly lines from the Google sheet ( if we might need it).
Before my problem of extraction of datas, no problem with it, my column was Text type without troubleโฆ
Perhaps another fantastic idea?
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |