Is it possible to use codes and separate tables when working with lots of rules, instead of large IF statements?

Hi there! Do you have a pro account in order to use a script? In general, I’m not sure I understand 100% what you’re trying to build. I think it’ll help if you would share some screenshots.

If your Table A has a formula that concatenates an {Input Code}, you could have another field that is a Link to Another Record type pointing to Table B.

Then use a simple Automation to copy the value of {Input Code} into the {Link} field. That way your {Output Code} could be a Lookup-type field.

Be aware of what your plan’s allotment of Automations per month if you go with this method.

Thanks both! Apologies for the poor explanation.

My overall aim is to avoid very lengthy IF statements as I have about 100 rules to work with.

Here is my Table A. Fields up to ‘Classification’ are filled by the user and that information is concatenated into a string called ‘Input Rule Code’.

I want this ‘Input Rule Code’ to search Table B (my table full of rules) for a matching code. This is because this table is my list of rules and next to the input codes are output codes such as below. This output code I want to be copied back to Table A.

This ‘Output Code’ string is then used to fill in the next fields in Table A. So dependant on what is inputted, that information will match a rule, of which has output information which I want to use to fill in the next few fields shown below.

I’m struggling to get my head around how I can search Table B for a matching code then take the Output Code from the matched row/rule and copy it back to Table A so it can be used to fill in the next fields.

Thank you so much for your help!

If this is possible, it seems to me a better solution than having a complicated IF statement with 100 rules inside of it.

I’m luckily on the Enterprise plan so can use scripts. They require a user action though do they not? I would like it to trigger automatically when all input data is entered.

The solution proposed by @Kamille_Parks is a great way of not using a script, I built the base quickly and recorded a video to demonstrate:

Let me know if you have questions re. that! Please find two screenshots in the following showing the automation trigger and how the record is updated:

W.r.t. scripts: Scripts can be triggered like automations and would therefore be triggered just like the automation in the video. If the solution above doesn’t work seamless, let me know and I’ll write a small script when I find the time :slightly_smiling_face:

For my suggestion to work, the primary field of Table B needs to be {Rule Output Code}, so you would need to shuffle your fields.