Forum Discussion

TimEgerton1's avatar
TimEgerton1
Qrew Member
4 years ago

Issue with Is Null

Hi, Can anyone assist with the IsNull part of this formula which is returning a syntax error of "Expecting )" at the first comma. var TimeOfDay TOD = [Interaction Time]; If( $TOD > ToTimeOfD...
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago
IsNull($TOD) ,"", "Other")

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
  • TimEgerton's avatar
    TimEgerton
    Qrew Trainee
    4 years ago
    Hi Mark,

    Tried that but it causes a syntax error on "Morning" of Expecting timeofday but found text.

    Tim

    ------------------------------
    Tim Egerton
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      4 years ago
      Wha is your field type for this formula field?
      It should be formula text.

      ------------------------------
      Mark Shnier (YQC)
      Quick Base Solution Provider
      Your Quick Base Coach
      http://QuickBaseCoach.com
      mark.shnier@gmail.com
      ------------------------------
      • TimEgerton's avatar
        TimEgerton
        Qrew Trainee
        4 years ago
        Hi Mark,

        I was using the wrong formula type.

        Thanks.

        Tim

        ------------------------------
        Tim Egerton
        ------------------------------