Hope you are building beautiful solution with Glide app but still have time to enjoy summer weather as well
Challenge of the day:
I want to display on a city detail item page the related custom requirements of the country.
Example:
Paris city page
I want to display the row about…. France
One table with cities as rows “cities”
One table with countries as rows “countries rules”
In the table “cities” i have a column with country
In the table “countries rules” i have a column with the country lol.
But every other times the relation columnd doesn’t work because it’s not a perfect match…
Most of the time when my users create a new row, they forget a Upper case or make a typo.
Any means ?
Impossible solution: relation column with “close/partial match” or option “disregard uppercase”.
For the upper case problem i guess i can just make a column that transform all in lower cases.
Interesting idea. As far as making the value lowercase, I think that’s a good way to solve half of your problem. I believe glide has a plugin to do that.
As for the close match, there obviously isn’t anything like that, but one idea would be to have a Correction table that has a column with correct spelling, and a comma delimited column with any alternative spellings that you can think of, and finally a Split Text column to convert that list of alternative spellings into an array. In the table that your users add rows, take that alternative spelling, create a single relation to the array column in the Correction table, and return the column with the correct spelling. Then use that lookup value for the rest of your relations. Not quite the same, but something like the old Soundex method, or the more modern Metaphone method, comes to mind. It’s not a perfect solution, and won’t catch everything, but could give you a way to catch most common misspellings.
The better alternative would be to only allow the user to select from a list of choices using a choice component. Then you have full control over the value that they enter.
