Forum Discussion

EOMDevelepors's avatar
EOMDevelepors
Qrew Captain
7 years ago

Link a formula rule based on content of a field in my table

Trying my luck...  I want to have a formula rule take the syntax of the formula based on a field within the table. So it would be something like this: If([field1]=2532, lookup the syntax in [fie...
APIs and custom code
AlexCertificati's avatar
AlexCertificati
Qrew Cadet
7 years ago
That's an awesome idea.
What happens when you use [field20] to push a string that plugs into the formula?
Can you flesh out your example a little more? I probably can't help, I'm just very interested.
AlexCertificati's avatar
AlexCertificati
Qrew Cadet
7 years ago
Well, I tried to push a formula as text into another formula, but I couldn't figure out how to escape all the quotes I'd need. Something like this would work in Excel:
If(true,"IF(TRUE,"&"""&SKY IS BLUE"&"""&","&"""&"SKY IS NOT BLUE)"&""","NEVER MIND")

It works, of course, with single quotes. the formula in tester is 
If(true,[testerr])


But this also shows that I think you're right - a formula won't evaluate the output of another formula as its input.