hiโฆ I am working on the creation of an email change template, with this fourmula, i am using a google doc for the templateโฆ
i want to filter and order a table for the report, when i use the natural โstartโ it works fine, but when a want use the โselectโ and โorderbyโ
it does not workโฆ
this is the instruction that failsโฆ
<< Start: ORDERBY( SELECT( [DETALLE NOTAs [LLAVE INT]], [TIPO PROD] = โFโ), [[TIPO SRV],TRUE)>>
<>
i put the picture to be more easyโฆ
Please, how can i fix to complete my report ?
the errors areโฆ Workflow rule โcorteโ Start expression โORDERBY( SELECT( [DETALLE NOTAs [LLAVE INT]], [TIPO PROD] = โFโ), [[TIPO SRV],TRUE)โ 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
expression โORDERBY( SELECT( [DETALLE NOTAs [LLAVE INT]], [TIPO PROD] = โFโ), [[TIPO SRV],TRUE)โ is invalid due to: Expression โORDERBY( SELECT( [DETALLE NOTAs [LLAVE INT]], [TIPO PROD] = โFโ), [[TIPO SRV],TRUE)โ could not be parsed due to exception: Number of opened and closed parentheses does not match.
Use the Editor to rename field
DETALLE NOTAs [LLAVE INT]
to DETALLE NOTAs
by LLAVE INT
The square brackets in the field name are confusing the parser. By eliminating them, you will fix the problem.
We have updated AppSheet to generate reverse reference field names that use โbyโ in place of the square brackets. We did not change existing field names in existing apps because doing that automatically might cause you problems. However, you can make this change manually.
Thx
Thx a lot !
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |