I’m getting this error in runtime:
Invalid syntax for field formula: {{TotalRecords}} / MODEL_LOOKUP(‘scheduledInitialAppointments’,‘TotalRecords’,‘grpCategories’,{{grpCategories}}). SyntaxError: missing ) after argument list
However, as you can see from the formula reproduced in the error message, there is just one open and one close parenthesis.
This would be amusing, if I didn’t need it to work. Even so, still slightly amusing.
Errors:
3. Invalid syntax for field formula: {{TotalRecords}} / MODEL_LOOKUP(‘AVRonIntake’,‘TotalRecords’,‘grpCategories’,{{{grpCategories}}})) *100. SyntaxError: missing ) after argument list
4. Invalid syntax for field formula: {{TotalRecords}} / MODEL_LOOKUP(‘AVRonIntake’,‘TotalRecords’,‘grpCategories’,{{{grpCategories}}})) *100. SyntaxError: Unexpected token )
Single quotes, double quotes.
double mustaches, triple mustaches.
Still getting the same error on the model_lookup function:
1. Invalid syntax for field formula: {{TotalRecords}} / MODEL_LOOKUP(‘scheduledInitialAppointments’,‘TotalRecords’,‘grpCategories’,{{grpCategories}}). SyntaxError: missing ) after argument list2. Invalid syntax for field formula: {{TotalRecords}} / MODEL_LOOKUP(‘scheduledInitialAppointments’,‘TotalRecords’,‘grpCategories’,{{grpCategories}}). SyntaxError: missing ) after argument list
3. Invalid syntax for field formula: {{TotalRecords}} / MODEL_LOOKUP(‘AVRonIntake’,‘TotalRecords’,‘grpCategories’,{{{grpCategories}}}) *100. SyntaxError: missing ) after argument list
4. Invalid syntax for field formula: {{TotalRecords}} / MODEL_LOOKUP(‘AVRonIntake’,‘TotalRecords’,‘grpCategories’,{{{grpCategories}}}) *100. SyntaxError: missing ) after argument list
5. Invalid syntax for field formula: {{TotalRecords}} / MODEL_LOOKUP(‘AVRonIntake’,‘TotalRecords’,‘grpCategories’,{{{grpCategories}}}) *100. SyntaxError: missing ) after argument list
6. Invalid syntax for field formula: {{TotalRecords}} / MODEL_LOOKUP(‘AVRonIntake’,‘TotalRecords’,‘grpCategories’,{{{grpCategories}}}) *100. SyntaxError: missing ) after argument list
7. Invalid syntax for field formula: {{TotalRecords}} / MODEL_LOOKUP(“completedInitialAppointments”,“TotalRecords”,“grpCategories”,Initial {{CaseType}} Appointment) *100. SyntaxError: missing ) after argument list
8. Invalid syntax for field formula: {{TotalRecords}} / MODEL_LOOKUP(“completedInitialAppointments”,“TotalRecords”,“grpCategories”,Initial {{CaseType}} Appointment) *100. SyntaxError: missing ) after argument list
9. Invalid syntax for field formula: {{TotalRecords}} / MODEL_LOOKUP(“completedInitialAppointments”,“TotalRecords”,“grpCategories”,Initial {{CaseType}} Appointment) *100. SyntaxError: missing ) after argument list
10. Invalid syntax for field formula: {{TotalRecords}} / MODEL_LOOKUP(“ReturnAppointmentsScheduled”,“TotalRecords”,“grpCategories”,{{grpCategories}}) *100. SyntaxError: missing ) after argument list
11. Invalid syntax for field formula: {{TotalRecords}} / MODEL_LOOKUP(“ReturnAppointmentsScheduled”,“TotalRecords”,“grpCategories”,{{grpCategories}}) *100. SyntaxError: missing ) after argument list
The Model lookup function only seems to work when I pass a static value for the last argument… it will not process merge syntax.
Both of the following work:
{{TotalRecords}} / MODEL_LOOKUP(“completedInitialAppointments”,“TotalRecords”,“grpCategories”,“Initial Pregnancy Appointment”) *100
{{TotalRecords}} / MODEL_LOOKUP(‘numberOfSchedulingLeads’,‘TotalRecords’,‘grpCategories’,null) *100
Is total records another formula field? You alerted us to that issue last week.
No, TotalRecords is a COUNT(Id).
I’m getting this same error when trying to merge in a field from an external data source.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.