Number searching - numerical or spelled

Hi everyone!

I’m wondering if it is possible when searching for a number in a glide app to ensure the results show inputs that are both numerical values and spelled?

i.e. if I search for ‘5’ or ‘five’, I’d like it to return entries that include both ‘five’ and ‘5’.

Thanks for your help!


Then you must have 2 columns to store those data. Let’s say you store a numerical number, then you must have another if then else column to convert them to spelled version. For example if numerical number is 10 then ten, 9 then nine, but it’s a lot of things to cover.

1 Like