"If" type formula

[dan-lowry]

Hello all!

Is there a way to create a formula that uses .present? on a string and then inserts one of two options into the field? Seems like there is a way to do it, but I'm having issues with the syntax. The specific use case is as follows:

[datapill1].present?

{"true": [datapill1].gsub(_([datapill1]).split(';').first()+"; ","")}

{"false": nil}

[ajorde]

[datapill1].present? ? ([datapill1].gsub(_([datapill1]).split(';').first()+"; ","")) : null

Sometimes I want the result to be an empty string instead of nil - in that case, I do this:

[[datapill1],''].compact[0]

[vijay-narsimha]

you can use something like this

[bala-s]

=_('data.logger.3dcdc175.message').present?? (_('data.logger.3dcdc175.message').gsub("dr","").split(";").first() + "; " + "") : nil

[dan-lowry]

Thanks for all the responses! I knew I was missing something and that second ? fixed it.