Attempting to process workflow via Mass Update. I ...
# ask-stanley-ai
j
Attempting to process workflow via Mass Update. I receive the following error upon preview of the Mass Update. There are no formulas used in my Mass Update Your formula has an error in it. It could resolve to the wrong datatype, use an unknown function, or have a syntax error. Please go back, correct the formula, and re-submit. Search: Transaction Search Formula: case when then 'T' end
c
AI generated answer (using internal Slack threads):
Based on the conversations provided, here are the answers to the issues raised: 1. The first issue is about an error in a formula used in a saved search. The error was due to a missing closing quote in the formula. The formula was corrected and the error was resolved. 2. The second issue is about a mass update that is not returning any results. The user was trying to update sales orders based on a search against vendor invoices. One of the responses suggested that the issue might be due to the criteria MainLine=F, as mass updates only pull and update header lines. Another response suggested that the process the user is trying to accomplish might not be possible with a mass update. 3. The third issue is about a workflow that is set to work on view/update but only works on update. The workflow is meant to copy a formula field value to a field with store value = T, making the field searchable. Several suggestions were made, including using a scheduled workflow or a user event script that runs on the billing transaction to update the original record. The user was also advised to trigger the update in a Map/Reduce script. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.835369468
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.830499
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.825525582
Please provide your feedback on this answer.