Discussions

Expand all | Collapse all

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.

    Thanks for your reply


  • 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.