Hi ! I have problems to make a report where t...

(Lavanderias El Sol) #1

Hi ! I have problems to make a report where the information of a whole day of work is presented, I have made an extract of the tables and I have copied the application to a minimum, to make it easier to understand, and to avoid some error on my part, however, the same problem continues to arise.

The problem is when generating the mail, where there is a Google Doc with the format …


i have been already followed several of their suggestions but the problem persists.

I have simplified it to the basic start expression, but I need to use: << Start: ORDERBY (SELECT ([Related NOTASs BY INT KEY], [TYPE PROD] = “F”), [[TYPE SRV], TRUE) >>

but, it does not recognize the names of the colums !!!

This is the error ! "Error: Workflow rule ‘email’ field ‘Body’ expression ‘[Related DETAILED NOTES BY INT KEY]’ is invalid due to: Unable to find column ‘Related DETAILED NOTES BY KEY INT’, did you mean 'Related DETAIL NOTE BY KEY INT '? "

how can it be an unknown column and then suggest it !!! ???

different errors, sometimes says that there is no such column …

please, this is the app, give me a hand with her …

My app: MyTestREF-261468

(Aleksi Alkio) #2

Try with <<Start: ORDERBY(SELECT([Related NOTASs BY INT KEY][KeyColumnName],[TYPE PROD]=“F”),[TYPE SRV],TRUE)>>

(Lavanderias El Sol) #3

i am soo said, it does not work yet (now i am in workfloww, but not

work… )!!!

i will be test in reports… the automatic templates does not work !!

Any other idea ?

(Aleksi Alkio) #4

Share the gDoc to me aleksi@1track.com and I can check what could be the reason.