Importing excel into multi select text field which is connected to another table inside same app

Question

I am trying to import data by adding existing data which is in another table but I am seeing a weird behaviour that rather than selecting the option which is already present it tries to create new option and as the option is more inside the main table it is throwing me error. Please give a reply ASAP

MarkShnierYou · Answer

Can you show a screenshot of the set up for those two fields that it is complaining about. It would appear that these are multi select text fields, but their choices are coming from the values in another table. If that is the case, then there is a Quickbase limitation that a multi select field can have it most 100 different choices.

It could be that your app requires a different set up such as a money to many drawing table. Let's start with looking at those fields and then we can discuss alternatives to using a multi select field.

Sign up

Login to the community