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:
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.
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
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.
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.
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.
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
Finally, go to preview, click the button and wait for the timer to finish. Check the original collection and it’s updated