Jump to content
  • 0

Entering text in a dropdown field


Agria
 Share

Question

Hi,

I have a dropdown field, over a long list (e.g. items).

I MS Access you can start entering text and the dropdown will complete it for you.

 

Can I do the same on Caspio?

 

Autocomplete is not a good solution as I want to write the display value and enter the ID under it to the actual field.  Thanks in advance.

 

Arie DeVeer.

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

  • 0

I'm not sure if that's possible with Caspio. You can type on the Dropdown field, and it will change the value according to what you typed, but you will not be able to see suggestions like in the Autocomplete fields

If you mean you want to have different Field for Display and Field for Value, there is a workaround using Autocomplete if that's what you want to achieve.

Step1. Use a virtual field for your autocomplete (Field for Display)

Step2 . Use your actual field, set as Cascading Text Field,

set its Parent Field as the Virtual Field in Step1,

set Cascaded By to the field you are using for the Step 1.

set its Field for Value to ID, and then hide this field

 

That way, you will only see the autocomplete field, type in there, and the actual field will take in the ID that corresponds to what you typed in Autocomplete Field.

 

 

Link to comment
Share on other sites

  • 0
On 2/4/2021 at 1:15 PM, TellMeWhy said:

I'm not sure if that's possible with Caspio. You can type on the Dropdown field, and it will change the value according to what you typed, but you will not be able to see suggestions like in the Autocomplete fields

If you mean you want to have different Field for Display and Field for Value, there is a workaround using Autocomplete if that's what you want to achieve.

Step1. Use a virtual field for your autocomplete (Field for Display)

Step2 . Use your actual field, set as Cascading Text Field,

set its Parent Field as the Virtual Field in Step1,

set Cascaded By to the field you are using for the Step 1.

set its Field for Value to ID, and then hide this field

 

That way, you will only see the autocomplete field, type in there, and the actual field will take in the ID that corresponds to what you typed in Autocomplete Field.

 

 

Just to add on this, you can download this PDF file for visual reference. 

Autocomplete.pdf

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...