Checking dates and comparing fields
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/op...
Forum Discussion
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
------------------------------
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
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendAre 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
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- Each scheduled product date requires a a submission of the form, so all individual records
------------------------------
Michael Samo
------------------------------- MarkShnier__YouBecause 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
------------------------------ - Also I should've clarified, the Products are from a multiple choice text list field