I am trying to create a field that will allow users to select multiple values from a drop down list and assign unique dates to each value selected.

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
I.e.

Field Name on Form:  CLIENTS PRESENTED TO.  
1) User selects values from a linked drop-down menu (list of clients)
2) User inputs date presented to each value (client) selected
3) User inputs rates for each value (client) selected.
Photo of Julie

Julie

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,542 Points 50k badge 2x thumb
You cannot do this with a simple Multi-select field type, but you can easily do this.

Set up a many to many relationship using a new third table.  The table would be called, perhaps Client Presentations.

So I will assume that you have a Table of Clients.

I will assume that you have or can create a table of Programs (or Products, ie the thing that you are presenting).

Then make a relationships where 1 Program has Many Client Presentations.


.. and make another Relationship where 1 Client has many Client Presentations.

aha, so  now you have a Many to Many relationships, Congratulations!

Put those new fields, the Presentation Date, and the Rate on that table too.

Then on both the Clients form and the Programs form put the Report link field on the form so on the Client record you see all Client Presentations for that Client and on the Program form you see all the Client Presentations for that Program. Set the FORM properties to not just show a link, but actually show the children right on the form.  You will want to make a pair of reports to be used on the forms to control the columns and the sort.

Lastly, set the form properties for those embedded report to allow the children to be editable.


So them the magic is that you are sitting on a Program record and you can add children on the fly in grid edit mode, to select the Client and then enter the Date and the Rate.