products table(10000registers)- orders(need products): possibility to search by name
Hello, my name is Jonas. Welcome to Caspio Support!
How may I assist you?
I am triying to lookup in a form, with the autocomplete by option, but since the field is linked by de id, it only allows me to search for the id and not by the name. any help?
how I can send you an screen shoot
You may send your screen shot to firstname.lastname@example.org.
Alright, One moment, Jordi.
subject: Att Jonas
Thank you for waiting, Jordi. Upon further checking, I'm afraid it is not possible to use the ID as a field inside the Autocomplete, you can only use them inside a regular dropdown.
Hello, are we still connected?
I just sent you another email, same subject
I will expain what i need. I have a main table with villas. I wana create task, each task related to a villa. To make it easier to look for the villa i tried "autocomplete by" option. But althoug in the table tasks villas apear by name, not by the id(as expecificated in the conection), with the entry form in only apears the id
please check last email, and I wonder if you can explain how i can do that?
Another example will be:
I have 10.000 product. and I create orders. How do I add the product in the order, searching by name and not by code? scroll down 10.000 products is impossible :)
I see. Thank you for that information, Jordi. You can actually display the name of the value instead of ID using the display value inside your Table relationships.
But note that it will only serve as the display, not actual value.
Here is a sample screenshot: https://c0acs764.caspio.com/dp/ba4a60009a119570a12e4c478dc4/files/3431315
in display value I have already name.
in table works but in entry form doesn
yes I have it, like that. and changed id for name
Yes, that is correct, Jordi. This is currently not possible for as a standard feature. We strive to enhance Caspio Bridge platform feature sets so please suggest your desired features in our ideabox: http://ideabox.caspio.com to communicate with our product team and for others to vote.