Discussions

 View Only
  • 1.  Summary Field Problems

    Posted 01-15-2021 10:20
    I am trying to pull a series of dates from a child table.  I believe that my problem is coming from the fact that the child table is also connected table.

    I've screenshotted the three attachments.  I'm needing the 4 dates in from the hull table.

    ------------------------------
    Sarah Burres
    ------------------------------


  • 2.  RE: Summary Field Problems

    Posted 01-15-2021 10:32
    Can we have a little more information about your relationships and which dates you are trying to pull?  Maybe use an example with real names for the data fields.

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



  • 3.  RE: Summary Field Problems

    Posted 01-15-2021 10:36
    I'm trying to pull maximum Keel Date , launch date, USCG COI Date, and Delivery date from the hull table. 

    The two relationships that are important here is the Orders and Hull.  I've screenshotted the relationship between the two.  Orders has many hulls.  Both tables are connected tables and are pulling data from another application.  I believe that is where my problem lies since the key field is Record ID# 2.  Therefore, the relationship between Order and Hull has a key field Record ID# 2 instead of Record ID#.  This is the record ID from the second application (connected app)


    ------------------------------
    Sarah Burres
    ------------------------------



  • 4.  RE: Summary Field Problems

    Posted 01-15-2021 11:31
    Are you getting an error? What is the problem that you're seeing? From your screenshots, everything looks right to me.

    ------------------------------
    Blake Harrison
    bharrison@datablender.io
    DataBlender - Quick Base Solution Provider
    Atlanta GA
    404.800.1702 / http://datablender.io/
    ------------------------------



  • 5.  RE: Summary Field Problems

    Posted 01-15-2021 12:22
    I’m not getting any date. It’s a summary field.




  • 6.  RE: Summary Field Problems

    Posted 01-15-2021 13:27
    Ok, in the relationship, is the [Related Order] field from the original table that you're syncing from or was it created when you built the new relationship? In order to pull the data correctly, it would need to be from the original table.

    ------------------------------
    Blake Harrison
    bharrison@datablender.io
    DataBlender - Quick Base Solution Provider
    Atlanta GA
    404.800.1702 / http://datablender.io/
    ------------------------------



  • 7.  RE: Summary Field Problems

    Posted 01-15-2021 19:01
    Sara,
    I gather that both the parent and child table are connect Sync tables.  The [Record ID#2] sound correct for the Key field of orders since it is a connected Sync Table.

    When you built the relationship to he also connected Hulls table, so you use the same field that was used in the real relationship?  is the field [Related Order] a connected field?  Does it have values in it?

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