Hello,
I need to create contract number if the form type is “Final survey”. Is it possible to generate contract number automatically only when this condition is met? If the form type is another value, then there is no contract number generated. I have tried to look into conditional formatting and if formula, but can’t find the solution.
Thank you for you help.
Hello,
I apologize for the delayed response. In Ragic, you can generate numbering based on selection fields. One method I can suggest is to create a “Form Type” field and set its type to “Selection.” This way, the numbering will be generated based on the field type. However, please note that if the selected value for the “Form Type” is not “Final Survey,” it will still generate a number. The “Form Type” will also be displayed alongside the numbering (as shown in the screenshot).
Additionally, you can create another field using an IF formula to display the contract number only when the “Form Type” is “Final Survey.” If the form type is anything else, it will show as blank. I have included a screenshot of the design mode and the resulting numbering effect. If you don’t need the auto-generated number field, you can set that field as hidden.
Please let me know if this solution meets your needs, and feel free to reach out if you have any questions.
