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 #]  = 12345, [Provider Tax ID] = 5555, [NPA #] = 5555

 If  [Service Type Authorization Description] = 'Flight 10' OR 'Flight 11' AND  [Responsible Payer] = 'Paid', then [Providing Agency] = 'Jetplace Services', [Provider ID #] = '6789', [Provider Tax ID] = 6666, [NPA #] = 6666

 

 

Formula Text Fields;

 

Providing Agency

Provider Id #

Provider Tax ID

NPA #



------------------------------
Del
------------------------------
  • Here is the formula for Providing Agency


    IF(
    [Service Type Authorization Description] = "Agency Hired",  "Airplane Services", 
    [Service Type Authorization Description] = "Flight 10"  AND  [Responsible Payer] = "Paid",  "Jetplace Services",
    [Service Type Authorization Description] = "Flight 11"  AND  [Responsible Payer] = "Paid",  "Jetplace Services")


    Post back if you have any problem with the other three formula fields. 



    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
    • Del's avatar
      Del
      Qrew Cadet

      Getting error related to "AND"



      ------------------------------
      Del
      ------------------------------
    • Del's avatar
      Del
      Qrew Cadet


      ------------------------------
      Del
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        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
        ------------------------------