When dealing with numeric custom fields within the CRM, I'm finding that I can only update these fields with static, pre-defined numerical values. However, my workflow requires these fields to be updated dynamically based on calculations that occur outside the CRM—in this case, on a Google Sheet where an automated formula calculates a value post-form submission.
To provide a clearer picture: imagine a scenario where each form submission results in a unique calculation on Google Sheets. That resulting number needs to be fed back into the CRM to update a custom field for each contact record. The system, however, doesn't seem to support the dynamic injection of these values back into the CRM fields; it only accepts a number that I manually input as a static value during the setup.
This is quite limiting, especially since the whole point of automation is to streamline the process without manual intervention. I'm sure I'm not the only one who would benefit from a more flexible system that accommodates dynamic updates.