Beam Help — independent expert support for Zoho. This note shows a practical approach to update a Quote percentage field automatically when a user picks a value from a dropdown on the Quote record in Zoho CRM using a workflow-triggered field update or a custom function where needed[2][6].
Why this matters
Keeping a Quote % field aligned with a dropdown choice removes manual edits and keeps reporting accurate for quotes and downstream records[2][6]. You use this when a dropdown selection should set or clear a numeric percentage on the same Quote record without repeated manual changes[2][6]. Our team is not official Zoho support, we provide independent guidance for configuration choices and common patterns[6].
Step-by-step
- Step 1. Decide whether a simple field update (workflow action) covers the requirement or whether you need a custom function for calculations or complex logic; field updates can set a field value directly and are paired with workflow rules[2][6]. [2][6]
- Step 2. Create the target Quote % custom field on the Quote module if it does not already exist; the field to be updated can be a standard or a custom field and must be present to be targeted by the update[2]. [2]
- Step 3. Navigate to the automation area to create a reusable Field Update: open Setup, go to Automation, then Field Updates, and click Create Field Update to begin defining the action[2]. [2]
- Step 4. In the Create Field Update dialog choose a Name, select the Quote module, pick the Quote % field as the Field to Update, and then enter the value to set (or choose Set as Empty to clear non-mandatory fields) for the matching dropdown option[2]. [2]
- Step 5. Create a Workflow Rule that fires when the Quote record is created or edited and the dropdown equals the specific value you want to map; associate the Field Update you created with that workflow so the percentage is applied automatically[2][6]. [2][6]
- Step 6. If multiple dropdown values map to different percentages, create one Field Update per mapping and one workflow rule per mapping, or use a single workflow that triggers different field updates via multiple actions tied to separate criteria branches where supported[2]. [2]
- Step 7. For calculations that depend on line items or dynamic data (for example, computing margin or deriving the percentage from other fields), implement a Custom Function invoked by a workflow rule instead of a plain field update; community examples show custom functions are commonly used to automate quote-related tasks when simple field updates are not sufficient[4][6]. [4][6]
- Step 8. Test the setup by editing a Quote record and selecting each dropdown value to confirm the Quote % field updates immediately after save or edit events; adjust the workflow criteria or function logic if the result is different than expected[2][6]. [2][6]
Common pitfalls
- Field Update limitations: a Field Update can only assign a static value or clear a field; any derived calculation requires a Custom Function instead[2][4]. [2][4]
- Trigger timing: workflows that run only on create or only on edit will miss changes if you chose the wrong trigger; ensure the rule fires on the events you need[2]. [2]
- Email/automation side effects: community posts show custom functions are often used to automate quote actions, and those functions can have unexpected side effects if not tested, such as sending emails unintentionally[6]. [6]
What to check
- Confirm the Quote % field exists and is the exact field selected in the Field Update definition[2]. [2]
- Verify the workflow rule criteria match the dropdown values and that the rule is enabled and set to run on create and/or edit as required[2]. [2]
- If you used a Custom Function, run unit tests for each dropdown choice to ensure the function sets the correct percentage and does not trigger unintended actions like sending emails unless intended[4][6]. [4][6]