Discussions

View Only

If statement based on field ID

• 1.  If statement based on field ID

Posted 07-15-2018 20:38
I want to do an if statement based on a field ID and the field ID number should be a value from a different field.

Like:

If(_fid_[field that has the ID I want to base on]>=1,true,false)

Thanks

• 2.  RE: If statement based on field ID

Posted 07-15-2018 21:16
Formulas work on field names, not field IDs.  They adjust automatically if you change the field name.

IF([my field]>1, true)

• 3.  RE: If statement based on field ID

Posted 07-15-2018 21:26
I understand that is the standard. I was wondering if there is anyway to base it on the field id.

• 4.  RE: If statement based on field ID

Posted 07-15-2018 21:34
You can do this:
`[_fid_6]`

• 5.  RE: If statement based on field ID

Posted 07-15-2018 22:05
Well, live and learn. Is there ever a benefit such syntax.

• 6.  RE: If statement based on field ID

Posted 07-16-2018 00:26
The only benefit I can see is, if I can implement it in a way where the field ID number can be looked up in another field. This will make things much more dynamic.

Let's see if Dan can come up with something.

I tried declaring a var by putting:

var text fid = "[" & "_fid_" & [field that has the ID I want to base on] & "]";

but when I put fid in the syntex its taking it as a text instead of a field id indicator...

• 7.  RE: If statement based on field ID

Posted 07-15-2018 22:40
Thanks Dan,

I am trying to put instead of [_fid_6] I want to replace the 6 with a field that has the value of the field id number....

Can this be done via script?

Like:  [_fid_[field that has the ID I want to base on]]

Thanks again

• 8.  RE: If statement based on field ID

Posted 07-16-2018 01:38
`Case([fid],  6, [_fid_6],  7, [_fid_7],  8, [_fid_8],  9, [_fid_9])`

• 9.  RE: If statement based on field ID

Posted 07-16-2018 03:01
Thats a good idea but still does not make it fully open since you still need to hard code each field ID

Thanks for the idea.