You can use a formula query to detect duplicates in the upload table and only upload the first duplicate. So you would import in a two step process. First step is into a temporary scratchpad type import file. Then run the import.
Make an admin record with one record on the table.
Make a button there to clear the scratch pad (API_PurgeRecords. Make a summary field of the # of records in the scratchpad. Show the button if there are records to clear.
Make a button to call the import page.
urlroot() etc .......?a=ImportExport
https://yqc.quickbase.com/db/bh4pwztea?a=ImportExportMake the formula query to flag duplicates which are not the first duplicate.
Make a saved T2T import
Make a button to run the import API_RunImport&ID=10.
Since the scratchpad fields are totally in your control, th field names will match the import sheet exactly
Workflow;
1. Click to clear
2. Click to initiate import screen and fields line up so click to import
3. Click to "commit" the scratchpad into the main table.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com------------------------------
Original Message:
Sent: 03-30-2022 18:35
From: Mike Tamoush
Subject: Find and append new unique values to secondary table
Did anyone ever solve this issue??
------------------------------
Mike Tamoush
Original Message:
Sent: 03-26-2020 20:50
From: Don Larson
Subject: Find and append new unique values to secondary table
Adam,
I have voted!
Lets see if the development team picks it up.
------------------------------
Don Larson
Paasporter
Westlake OH
Original Message:
Sent: 03-25-2020 06:40
From: Adam Krzyzanek
Subject: Find and append new unique values to secondary table
@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 (Your Quickbase Coach)
------------------------------
Adam Krzyzanek
Original Message:
Sent: 03-23-2020 07:36
From: Don Larson
Subject: Find and append new unique values to secondary table
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
Original Message:
Sent: 03-23-2020 06:58
From: Mark Shnier (YQC)
Subject: Find and append new unique values to secondary table
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
Original Message:
Sent: 03-23-2020 05:52
From: Adam Krzyzanek
Subject: Find and append new unique values to secondary table
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
------------------------------
Adam Krzyzanek
Original Message:
Sent: 12-14-2017 21:29
From: Heidi Atwood
Subject: Find and append new unique values to secondary table
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?