Discussions

Expand all | Collapse all

Dynamically get an associated field?

  • 1.  Dynamically get an associated field?

    Posted 06-11-2020 12:17
    This is a slightly convoluted scenario.  I'll do my best to describe the situation.  I have two tables with related but not identical data.  The project number is the key in the Projects table and the activity number is the key in the Activity table.  Additionally, the Activity table is a child table of the Projects table.  There is a location number in the Activities table that is associated with the activity number and there can be multiple location numbers at the same address because at one point the location number was associated with a particular device rather than the physical address.

    What is the best way to dynamically associate the location number to each related project number.  One additional complication, it is possible (in fact probable) to have multiple activity numbers for each project number, although the location number ideally will be the same .

    ------------------------------
    Paul Peterson
    ------------------------------


  • 2.  RE: Dynamically get an associated field?

    Posted 30 days ago
    Would it be a good bet based on the lack of a response that this is not possible using Quick Base?

    ------------------------------
    Paul Peterson
    ------------------------------



  • 3.  RE: Dynamically get an associated field?

    Posted 30 days ago
    I read the post a few times, but could not understand what relationship if any the locations numbers had to anything.  I could not tell if they were a separate table or just a field on the Activity Record.

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



  • 4.  RE: Dynamically get an associated field?

    Posted 30 days ago
    The data is in two tables, a Projects table using the project number as the key and an Activities table using the activity number as the key.  The Activities table is a child of the Projects table.  There are frequently multiple activities for each project.  I need to find a way to get the location number from the activity into the Project table.  While I'm talking about this relationship, I also need a way to associate the activity status of ALL activities to the project number. (this association would be based on the location number)

    ------------------------------
    Paul Peterson
    ------------------------------



  • 5.  RE: Dynamically get an associated field?

    Posted 30 days ago
    That would just be a regular combined text summary field.  If the location number is a numeric field, then you will need to use a formula field and ToText (.  ) to change it to text to roll it up.

    if you don't like the pill appearance, then there are easy formulas to change the appearance depending how you want the locations separated, like with a space or a comma space, or vertically separated.


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



  • 6.  RE: Dynamically get an associated field?

    Posted 30 days ago
    The Activities table is the child in this relationship.  I need to get the data into the parent table.  A summary field does not appear to be an answer.

    ------------------------------
    Paul Peterson
    ------------------------------



  • 7.  RE: Dynamically get an associated field?

    Posted 30 days ago

    Re.  A summary field does not appear to be an answer.

    Why not?



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



  • 8.  RE: Dynamically get an associated field?

    Posted 30 days ago
    I've been able to create a summary field in the Activities (child table) but I need it in the parent table.

    ------------------------------
    Paul Peterson
    ------------------------------



  • 9.  RE: Dynamically get an associated field?

    Posted 30 days ago
    Now I'm more confused.  You said you have two tables. One Project has Many Activities.

    How  can you have a Summary on the Activity Table?  Summary fields are inherently on Parent records.

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



  • 10.  RE: Dynamically get an associated field?

    Posted 29 days ago
    That is correct, but the relationship as it was set before I started with this project has the activities as the child.

    Both of these tables are pulling from different modules of an Oracle database.

    ------------------------------
    Paul Peterson
    ------------------------------



  • 11.  RE: Dynamically get an associated field?

    Posted 29 days ago
    If the following statement is true

    Additionally, the Activity table is a child table of the Projects table. 

    Then I am not sure what more I can add. If you make a combined text summary field on that relationship then you will have a list of all the locations up on the parent projects record.

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



  • 12.  RE: Dynamically get an associated field?

    Posted 29 days ago
    Finally starting to recover from my chronic rectal-cranial inversion.  I'm getting closer to what I need. a little more playing and I should be there.  Thank you for your help and patience Mark!

    ------------------------------
    Paul Peterson
    ------------------------------