Verifying if this a bug or not

Get Help
1

Hi - I’ve created a list with some filters. One of the filters is matching a text field for a “Current” record to a corresponding field of a list of records. (i.e. show me all comments with title value = current record title value). For most records, the filter works as expected. For some, specifically text values that include apostrophe or exclamation mark, the filter does not work (in which the system assuming to match).

Is there an issue with special characters and filter matching that others have seen?

1 Like
2

You’re right Adalo doesn’t allow you to filter exclamation marks, apostrophes, etc. It only allows us to filter letters and numbers.

What you can do instead is to create another text field without any special characters and filter them that way.

example to filter a list with the name “you’re okay?”
1

in the fake name field, you rename it to “you re okay”
2

1 Like
3

Thank you for that. good tip! Dumb question maybe, but how would you automate the input of the fake field and remove those special characters?

1 Like
4

You’re welcome, thanks! To give you the best solution for your case, is this collection just a list of names (example countries), or does it have other fields that have to be updated constantly (example User collection)

In other words, is it possible to delete this collection and create a copy of it?

5

Good question. It’s basically a comment board. This collection is the parent comment. Text input includes title, URL and body.

1 Like
6

Okay, the steps are a bit long but will definitely solve your problem.

1- after creating a similar “fake name” field to the collection, download it and open it in excel.
In the fake name column, add this formula the second cell:

=UPPER(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,“?”,“”),“,”,“”),“'”,“”),“.”,“”),“-”,“”))

you can add as many characters as you want between the first two “” and the replacement between the second two “”. For example to remove a question mark put “?”, “” (as shown in the formula above). After you finish click enter, copy the formula to all other cells, and save the sheet.

image
image1035×295 6.96 KB

2- in Adalo create a new collection and upload the saved sheet. On any page add a button and link it to an empty screen

image

3- in the empty screen add a custom list of the collection you want to update. assign the first text to the “Name” magic text.

image
image

Add a new text component next to it, and make it a list of the new collection. add a filter to it similar to the image below. and assign to the text component a magic text of the new collection fake name.

image
image
image

Add a timer and set it to countdown 5 seconds. Make it a list of the new collection with a similar filter to the image below.

image
image

For the timer component add an update action of the original collection and add the magic text of the new names of the new collection to update the new name column of the original collection

image
image425×810 20.7 KB

Finally, go to preview, click the button and wait for the timer to finish. Check the original collection and it’s updated :tada:

7

Wow. very thorough. thank you so much!

1 Like
8

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.