Can you create multiple date entries on one table, based on a single entry from another table that has a relationship to it?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I have a table set up for my employees to submit vacation requests. Once the requests are approved, I have the table set up to assign a "green" background to them and display them on a calendar report. It works well, however, it will only display the background color on the report on the first date of their vacation, I know this is a known frustration with QB. My thought would be to have QB (in a separate table) create multiple entries based on one vacation "request" my employees put in. As an example, if they put in a request to be off January 1st - January 5th, they would only put in that one request but after they hit submit QB would - on a separate hidden table - actually create 5 entries for that request. Then the report displaying all the vacations would be generated from that hidden table and each of the 5 days would be colored and have the names of the person who requested the vacation. I'm relatively new to QB so I don't know if this is even possible, but it seems doable, at least in my mind. Anybody know how this might be accomplished?


Photo of ROBERT

ROBERT

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of Blake Harrison - DataBlender

Blake Harrison - DataBlender, Champion

  • 100 Points 100 badge 2x thumb
This can definitely be done, but it would require some QuickBase gymnastics in order to keep everything in native features. A more simple way to accomplish it would be to build a script that would do all the heavy lifting for you once the record was saved. 

Either way, you have to have something that understands how many days have been requested and what each date is. If you're new to QuickBase, either of these could be a pretty complex undertaking.