Discussions

Expand all | Collapse all

Find and append new unique values to secondary table

  • 1.  Find and append new unique values to secondary table

    Posted 12-14-2017 21:29
    I have an app where I run a daily upload of data (much of it duplicate due to the nature of the source), but sometimes my daily upload includes a new record that needs to be added to a secondary table within the app. The key field in the secondary table matches one of the fields in my daily upload. I have set up a QB action that should identify new unique values in the field related to the secondary table's key and copy these records. But I am running into a problem. Sometimes my upload will include several rows with the same value in the field that I want to use to populate the secondary table's key field . When this happens, my action is registering an error. I only need the value in one of the duplicate lines to write to the secondary table, but I need to preserve all of the lines in the primary table. Any suggestions?


  • 2.  RE: Find and append new unique values to secondary table

    Posted 02-16-2018 22:22
    If you have the ability, I'd use a webhook to a script that will query the table, and then do a single import based on a the combined information, thus limiting the duplicates.


  • 3.  RE: Find and append new unique values to secondary table

    Posted 17 days ago

    Did you manage to solve this problem?
    I have similar one while using Automations.

    What I want to do on a daily basis run automation to copy all not existing data in Table 2 from Table 1


    Daily automation to copy Unique value from Table 1 to Table 2


    ------------------------------
    Adam Krzyzanek
    ------------------------------



  • 4.  RE: Find and append new unique values to secondary table

    Posted 17 days ago
    I too am looking to so,be that same problem which is a feature needed in so many applications where we need to auto create parents.  I'm hoping that there is a solution using Pipelines, but so far I have not been able to crack it.

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



  • 5.  RE: Find and append new unique values to secondary table

    Posted 17 days ago
    If there is a way to do this with out scripts, I would love to see it.  I am sure there would be many other uses.

    ------------------------------
    Don Larson
    Paasporter
    Westlake OH
    ------------------------------



  • 6.  RE: Find and append new unique values to secondary table

    Posted 15 days ago
    @Evan Martinez - Maybe any solution for us?

    Please vote here:

    https://quickbase.uservoice.com/forums/111823-quick-base-product-feedback/suggestions/40015141-copy-unique-data-to-other-table

    @Don Larson, @Mark Shnier (YQC)​​​

    ------------------------------
    Adam Krzyzanek
    ------------------------------



  • 7.  RE: Find and append new unique values to secondary table

    Posted 15 days ago
    I gave it 3 votes.  There are a couple of Pipeline Webinars coming up, plus another opportunity to learn more about Pipelines later in April.  Maybe I will be smarter after I attend them :).  But I'm concerned that even if there is a Pipelines solution it may be too "step intensive .. we will see.

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



  • 8.  RE: Find and append new unique values to secondary table

    Posted 14 days ago
    Adam,

    I have voted!   

    Lets see if the development team picks it up.

    ------------------------------
    Don Larson
    Paasporter
    Westlake OH
    ------------------------------