ConfiForms: Show text dependent on field value in table view (using if-condition ?)

[Christian Sieber]

I've a form collecting information about hardware ownership in our company.

There is one user-field in the form having fieldname owner.

By the third symbol of the owner's username I can derive the employee relationship (employee or contractor).

How do I add a column in table view labeled "employee relationship" that shows "contractor" in case of the username has a "9" as third symbol. In all other cases the column should show "employee".

I've tried to achive this using a if-condition in the form field macro. This didn't work, the column was not displayed at all.

Field name value:

IF([entry.owner.id.trimLeft(2).trunc(1)]==9,"contractor","employee")

Thanks for your help
Christian

[Alex Medved _ConfiForms_ · Accepted solution]

Hi

You cannot use the formulas directly in the field name, but you can do it through the virtual function. And evaluateFormula  function should be able to help

Set the field name to something like

id.evaluateFormula(IF([entry.owner.id.trimLeft(2).trunc(1)]==9,"contractor","employee"))

 Alex

[Craig Smith]

Hi Alex,

I am trying something similar, but basically if lcat field equals "Monitoring and Alarming", then entry.lcatergory field output will be "Monitoring/Alarming-Other".

id.evaluateFormula(IF([entry.lcat]==Monitoring and Alarming,"Monitoring/Alarming-Other"))

[Alex Medved _ConfiForms_]

It is a bit wrong place to put that expression (as a default value for the hidden field)

Probably it should be a formula field instead

However, something what I was mentioning can be put directly into the IFTTT JSON mapping

[entry.id.evaluateFormula(IF([entry.owner.id.trimLeft(2).trunc(1)]==9,"contractor","employee"))]

Of course you can have own formula expression, mixing https://wiki.vertuna.com/display/CONFIFORMS/Supported+math+operators%2C+formulas+and+functions with https://wiki.vertuna.com/display/CONFIFORMS/Virtual+functions