Select That Also Accepts Manual Entry Like If Defined as Text Data Type

Applications Forms
#1

Is there a way to enable a Select field to use an Automatic lookup method to show distinct field values and also allow manual entry in the event the desired selection is not already present in the table? For example, a table column may already have many entries of items like Dog, Cat, Bird. The lookup method is automatic, and a hypothetical SQL select statement is:

SELECT DISTINCT Animal
FROM zoo
ORDER BY Animal

Without creating another application, how might I enter a new animal like Cow if Cow is not already a Select option?

#2

You cannot do this with type SELECT.

But there is a workaround if you are using Type TEXT AUTO COMPLETE. Supposed your select data only contains only DOG, CAT and RAT inside the database, now you want your form to accept MOUSE, to achieve this, check my screenshot attached.

[ATTACH=JSON]{“data-align”:“none”,“data-size”:“full”,“data-attachmentid”:88654}[/ATTACH]

autotextbox.jpg

#3

workaround is not working for me. I get an error since the testname field could be empty.

but another way is

  • use auto text complete + normal lookup
  • enable the capture text
now you can enter a value or choose one from the list