Forum Discussion

EOMDevelepors's avatar
EOMDevelepors
Qrew Captain
7 years ago

If statement based on field ID

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
Formulas and functions
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    Formulas work on field names, not field IDs.  They adjust automatically if you change the field name.

    IF([my field]>1, true)
  • EOMDevelepors's avatar
    EOMDevelepors
    Qrew Captain
    7 years ago
    I understand that is the standard. I was wondering if there is anyway to base it on the field id.

    Thanks for your reply
    • EOMDevelepors's avatar
      EOMDevelepors
      Qrew Captain
      7 years ago
      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...
  • EOMDevelepors's avatar
    EOMDevelepors
    Qrew Captain
    7 years ago
    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
  • EOMDevelepors's avatar
    EOMDevelepors
    Qrew Captain
    7 years ago
    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.