Forum Discussion

Del's avatar
Del
Qrew Cadet
4 years ago

Formula Fields

I am in need of a formula with a few conditions. See criteria below If [Service Type Authorization Description] = 'Agency Hired', then [Providing Agency] = "Airplane Services", [Provider ID #]  =...
Formulas and functions
Del's avatar
Del
Qrew Cadet


------------------------------
Del
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago
Del would you please copy and paste the code into the thread here and I will try it in my own app?

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    4 years ago
    .. also please confirm that the field type is formula text.

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      4 years ago
      I tried the code here and it worked.

      IF(
      [Service Type Authorization Description] = "Agency Hired Respite",  "Empower U. Services Corp", 
      [Service Type Authorization Description] = "Intensive In-Home Clinical"  AND  [Authorization - Responsible Payer] = "Medicaid",  "Clinical Care LLC",
      [Service Type Authorization Description] = "Intensive In-Home Clinical"  AND  [Authorization - Responsible Payer] = "Medicaid",  "Clinical Care LLC")

      ------------------------------
      Mark Shnier (YQC)
      mark.shnier@gmail.com
      ------------------------------
      • Del's avatar
        Del
        Qrew Cadet
        4 years ago
        Yes it is formula Text, still giving me that error


        ------------------------------
        Del
        ------------------------------