Delivery Scheduling
Hello, I have a project where I want to track deliveries. There are contractors who make the deliveries, and the contractors are connected to a project. I want a way where the contractor can select...
Forum Discussion
I think you're on the right track. You'll need your "Deliveries" table to be a child of the Project and probably have a field for "Contractor" that would be a user field. I would also set the permissions for the role the Contractors are in to only be able to edit a "Deliveries" record if that "Contractor" field is blank OR it is their user. And don't let them edit the "Date" or "Time" field on the records.
Also, when you're adding this to your Project form, I would have it so that when a Contractor looks at it, you have one of two setups:
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
Also, when you're adding this to your Project form, I would have it so that when a Contractor looks at it, you have one of two setups:
- The Contractor sees a button - "Choose Delivery Slot" - that updates the "Contractor" field automatically. This button would also need to be shown as "Release Delivery Slot" if the current user is in the "Contractor" field so that they can remove their selection and choose another time.
- The list of available Dates/Times is setup as editable on the Project Form
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
Hi Blake,
Hope all is well. Thank you for this info on the setup. To add to what Mackenzie said above,
Our Projects table is currently the parent to "Deliveries" so all deliveries are linked directly to a project. We also have a Contractors table that is linked both to "Deliveries" and "Projects" as well. In this scenario, our contractor can have many folks accessing the Deliveries area, so i created a User List field in the Contractor table and made it so that the members of that "Contractor" are only able to view/modify records that they created but are unable to change dates/times once a record has been submitted.
In your response above you mentioned in one of the Two Setups.
That is where I am struggling on, is configuring a dynamic dropdown that queries a table for all available times for the day for that particular project.
Any help with this would be greatly appreciated.
------------------------------
Dave Medeiros
------------------------------
Hope all is well. Thank you for this info on the setup. To add to what Mackenzie said above,
Our Projects table is currently the parent to "Deliveries" so all deliveries are linked directly to a project. We also have a Contractors table that is linked both to "Deliveries" and "Projects" as well. In this scenario, our contractor can have many folks accessing the Deliveries area, so i created a User List field in the Contractor table and made it so that the members of that "Contractor" are only able to view/modify records that they created but are unable to change dates/times once a record has been submitted.
In your response above you mentioned in one of the Two Setups.
- The Contractor sees a button - "Choose Delivery Slot" - that updates the "Contractor" field automatically. This button would also need to be shown as "Release Delivery Slot" if the current user is in the "Contractor" field so that they can remove their selection and choose another time.
That is where I am struggling on, is configuring a dynamic dropdown that queries a table for all available times for the day for that particular project.
Any help with this would be greatly appreciated.
------------------------------
Dave Medeiros
------------------------------
- Dave,
Where is the data of available times?
Is it unique to every Project?
Is it a common set of times that applies to all Projects?
Does either diagram describe the app correctly?
Also is there more than one delivery allowed per day?
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------ - MarkShnier__You
Qrew Legend
Dave & Mackenzie, I do know a native technique which would allow you to launch off a Project and be presented with a regular Quick Base Table Report of Qualifying Open Delivery Slots (so dynamic filters and filter box is available) and click to select which Delivery Slot.
It would probably be an hour or two of consulting time. Contact me directly by email if you want to take this off line.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
