reference field is not editable (replaced by drop-down)

Question

I have a reference field in the table 1, which provides look-ups from table 2.

For some reason after setting a connection it becomes a drop-down, containing all values from table 2 and it does not allow to make manual inputs to this field. The only option is to "Create new entry in the reference table", which is not what we need.

Api calls and import functionality still works, but straight input has been replaced by this drop-down functionality.

Is there any way to switch this drop down off and allow user straight inputs?

------------------------------
Stepan Gurov
------------------------------

MarkShnierYou · Answer

If you want free form entry, then you can break the relationship (but do not delete the reference field or you will lose all your data) and then create a new field called [xxx for relationship]. Make it a formula field equal to your data entry field.

Then make the relationship based on the formula field.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------

Sign up

Login to the community