Skip to main content
Question

Automation and Unique Fields

  • December 10, 2020
  • 0 replies
  • 26 views
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
------------------------------
This topic has been closed for replies.

  • BlakeHarrison
  • Quickbase Alumni
  • December 10, 2020
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/
------------------------------
Terms & ConditionsAccessibility statement