Welcome to the community, @Tom_H! :grinning_face_with_big_eyes:
No. In many programming languages, what you want would be accomplished with a command/function often named eval (short for “evaluate”). You feed it a string that represents the code you want to run, and it runs it. Unfortunately Airtable doesn’t support this kind of behavior currently (though it’s a cool idea, and one that you might consider adding to the Product Suggestions category).
The end result you seek can be done through other means, though. What I would suggest is to ditch the [Job] table, and change the {Job} field in [List] into a single select. From there, each formula field would do its own switching between the appropriate mini-formulas via the SWITCH() function. Here’s how {CCF 1 Formula} would look with this modification:
SWITCH(
Job,
"Job 1", Trim(Upper({CIF 1})),
"Job 2", Upper(Concatenate({CIF 1}, " ", {CIF 2})),
"Job 3", Trim(Upper({CIF 1}))
)
Do the same for the other formula fields with their respective formula combinations pulled from the [Job] table.
While this would be fairly manageable for a setup where there are only going to be a few job possibilities, it would become a bit unwieldy for larger datasets.
That aside, I’m curious about the data you’re working with. What source gives you the field contents with such disparate information? {CIF 2}, for example, contains a last name in some records, a full name in others, and a date reference in still others. If there’s any way of cleaning up the data before it comes into Airtable, I suggest doing that, rather than trying to make all the options work on the back end via formulas.
