Forum Discussion

AshleyGwozdz's avatar
AshleyGwozdz
Qrew Member
4 years ago

Multi Select Date & Text

I'm pretty new to QB and databases in general. 

First question:

Is there a way to create a field in which the user selects a date, and then if they have a second or third date, they can use an "Add new" button on the form to add a new date which gets recorded in that field (attached to the same record).   

Second question:

If I need to record a date and an associated text entry to display as one piece of information (date + text), how would I do that? 

And last - is there a way to combine first and second questions so that they would work together somehow? User records a date and a corresponding piece of text, they are displayed together in a report or a form view, and then Add New would let them do it again?

Thanks!!

------------------------------
Ashley Gwozdz
------------------------------
Relationships
Tables and fields
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    4 years ago
    Ashley,

    I'm struggling to understand this part of the question here.

    Is there a way to create a field in which the user selects a date, and then if they have a second or third date, they can use an "Add new" button on the form to add a new date which gets recorded in that field (attached to the same record).   

    Are you looking to have a child table of additional "dates" for the same parent record?

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • AshleyGwozdz's avatar
      AshleyGwozdz
      Qrew Member
      4 years ago
      The user wants to record the announcement date associated with the parent record, but states that sometimes there are multiple announcements for that record, along with notes for each announcement date and would like to record each time that occurs. 

      Is a child table the best way to do this?

      ------------------------------
      Ashley Gwozdz
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        4 years ago
        Yes, a child table would be the best set up.

        The parent table could be used for the initial announcement and the initial announcement date. And then the child table could be for follow up dates and messages related to that original announcement.

        Records could be entered after the parent record is created or if they use Chase needs it, it may be distraught records are future announcement dates, the children can be entered in grid edit mode while entering the parent record. That way they all get saved together.

        QuickBase can do any kind of formula to combine text and dates.

        Let me know if you are going the child table route and i can help you with a formula to roll up all the child table data into a single field on the parent record called perhaps [Updates].

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