Discussions

Expand all | Collapse all

Checking dates and comparing fields

  • 1.  Checking dates and comparing fields

    Posted 18 days ago
    I am having trouble trying to use the dates field in a scheduler app and then check a different field in my form to see if it is the same the as the day before and after. If the fields are the same/open/null then it would allow the request to go through, otherwise it would prevent the scheduling because of the secondary field. Is it possible to do this on the quickbase platform?


  • 2.  RE: Checking dates and comparing fields

    Posted 18 days ago
    Yes, easily done, but can you express more clearly the logic that you want to have and we can help you with the formula syntax.

    For example, if we make a formula checkbox field called called [OK to Allow Request] we then need to list the conditions and if they would make the checkbox checked or unchecked.  We also need to understand if the day before is calendar days or business days.

    IF(
    [date field 1]=[date field 2], true,
    [date field 1]= [date field 2]- days(1), true ).

    etc.. need to have you say your complete logic listed by each test that needs to be done in the sequence they need to be done..

     



    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Checking dates and comparing fields

    Posted 18 days ago
    Okay I follow and thank you for the response

    My current logic is to check if the day before and after is scheduled for a product, if said product is the same(or empty) as the day before/after then there would be no issue with the system and the request can go through. If the product is different then I'd want to display a message that the product on the day before/after is different and a new date must be selected. Ideally I'd like to limit this to business days with Monday not being a possible option throwing a "setup day" to the user and limiting the total products a week to three days e.g. Tues with Product A and Thurs/Fri with Product B and Tues-Thurs with Product C are both viable outcomes

    Please let me know if I need to clarify on my logic

    ------------------------------
    Michael Samo
    ------------------------------



  • 4.  RE: Checking dates and comparing fields

    Posted 18 days ago
    Are all these dates on a single record or across multiple different records?

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 5.  RE: Checking dates and comparing fields

    Posted 18 days ago
    Each scheduled product date requires a a submission of the form, so all individual records

    ------------------------------
    Michael Samo
    ------------------------------



  • 6.  RE: Checking dates and comparing fields

    Posted 18 days ago
    Because you are asking for a comparison of dates across records, and the additional conditions you have explained, this becomes more complicated.  This would require some one on one assistance to understand your app.  If you would like to have some professional assistance, feel free to contact me via the email in my signature line.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 7.  RE: Checking dates and comparing fields

    Posted 18 days ago
    Also I should've clarified, the Products are from a multiple choice text list field