Forum Discussion

RonalAlemancamp's avatar
RonalAlemancamp
Qrew Member
5 years ago

Automation and Unique Fields

I have an automation which copies some information from one app to another app. One of the fields is required and unique but when the automation runs it will not copy the information. Is the automation not able to copy unique fields or is there a way around to copy unique fields?
The field I need to copy is a multiple choice, Yes or No answer.

------------------------------
Ronal Alemancampos
------------------------------
Quickbase Automations
Tables and fields
  • BlakeHarrison's avatar
    BlakeHarrison
    Qrew Captain
    5 years ago
    If you have a multiple choice field marked as Unique, you are going to be limited in the number of records you can create on that table. Example: You have a Yes/No multiple choice field that is required to be Unique. Once you have a record that has Yes selected, you will not be able to create another record with an answer of Yes. If you did, then it would not be Unique. Is that your intent?

    If you try to copy a record with a Yes value from one table to another and there is already a Yes value in an existing record in the new table, it won't copy because this would cause a duplication.

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