Skip to main content
Question

Matching similar time frames between tables

  • July 8, 2020
  • 0 replies
  • 30 views

Hi,

I'm looking for a possible solution to the following situation.

I have a table for providers who have a certain availability, as well as a table for clients that have a certain availability.  I'm trying to match up clients with providers, depending on these availabilities.  

For example, if a provider has an availability from 10am to 4pm, and several clients that have availability in that range, is there a way to show a list (report) of the clients in the providers record?  Say I have 30 clients, and 5 of them are available in that time frame, how can I match them up?  Of the 5 clients, they fall within that time frame, but not exactly.  One might be available from 12pm to 3pm, another 10am to 4pm another from 11am to 2pm, etc.

I want to be able to show these possible clients on the provider record, so someone can see if there is a good fit, and assign the client to the provider if they decide to do so.  

Does anyone have a method they can recommend to accomplish this?  Can it be done using native Quickbase features?  I realize this isn't a simple task, but I don't want to spend a lot of time trying ideas that would end up going nowhere.  Any tips or help would be greatly appreciated.  

Thanks!

------------------------------
Dana Hauser
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
Are these 1 hour meetings?

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