Hello, I made an app to create waybills with an api of a packaging company, I already have it working and I made some text inputs to modify the json body that is sent to create the waybill, what I want to do is that when you put the zip code in the zip code text input it autocompletes the city text input with its respective city, I made a table in retool database with the zipcode as primary key with its respective city in the other column but I do not know how to achieve that when I put the zip code it autocompletes the city in its text input
Would a solution like this work?
I have an event that triggers on blur of the zip code input. It searches my query for that zip code and then sets the city text input to be equal to the corresponding city:
If this doesn't quite fit your use case, please let me know & I'll take another look!