Skip to main content
Question

Automations turn off after an error

  • August 15, 2018
  • 0 replies
  • 56 views
I'm trying to add a value from Table A as a unique primary key into Table B. However, sometimes there are duplicate values in Table A, so I WANT them to error out and not be added to my table. However, the automation automatically shuts itself off after one error. This is really annoying because I still want the automation to continue even if there is an error. 

For example:
Table A 
1:10
1:11
1:10

Table B
1:10
1:11

That is the final structure I'd like. 

I understand that it doesn't want to run into infinite loops, but that isn't what's happening here. 

Is there any way to do this with automations, or do I have to write a custom script to populate this table with a loop checking for duplicates? 
    This topic has been closed for replies.

    QuickBaseJunkie
    Forum|alt.badge.img+15
    Have you considered a table to table import? You can set it up to merge records with the same ID.

    You can then automate the import with an Automation.

    • LucasBuxman
    • Registered
    • April 13, 2020
    Hi all,

    I'm wondering if there was a solution to this?  I think of it as an issue of not being able to 'uniquify' data natively in Quickbase.  I see a suggestion to 'use a t2t import' to do this but that will fail if Table A has multiple records that are desired to be uniquified as a primary key in Table B.

    There has to be a better way than pulling that data out of QB and pushing it back in after uniquifying in a separate tool.

    ------------------------------
    Lucas Buxman
    ------------------------------
    Terms & ConditionsAccessibility statement