Enable Disable Container based on record

[Labhesh]

Hi All,

When uploading to Gallery, we’re trying to prevent a "Character Parse" error in Formula (3) when no records are available for parsing. Currently, the workflow correctly displays a "No Records" message, but the Formula tool still triggers a Character Parse error. Please note that we have intentionally left the text input blank to simulate our intended scenario where no rows are available.

One approach we're exploring is to dynamically disable or enable the Control Container based on the Record Count to prevent the formula from executing unnecessarily. However, we haven’t yet figured out how to implement this. Any suggestions or guidance would be appreciated.

[TheOC]

hey @Labhesh ,
If you are trying to a numeric formula on column 'A', you can get around your formula tool creating errors by changing your formula to:

Or:
Changing your data type in the select tool to a numeric type:

The reason this works is that when the text input doesn't have any data for a field, it assumes it is text data (string). The formula you have created will error with a string as you cannot add a numeric (10) to a string. The reason both of these fixes work, is they force the formula to recognise the column as a number, either by changing it prior to the formula in the select tool, or changing it within the formula with the ToNumber expression.

I suspect this is a nicer route for you than forcing the control container to stop running the formula if no records are received. Let me know if I have misunderstood your scenario however.

[caltang · Accepted solution]

@Labhesh let me introduce you to a new way of doing it rather than using a control container:

Introducing DETOURS! If they fulfil your criteria, it triggers the path to proceed to the formula or not. Use this logic and concept to get what you want.

If the above solved your need, kindly like & mark as accepted solution so that you may help others find the solution more quickly + to close the thread as is. Thanks!

[Labhesh]

@CA Thank you for your support :) It worked