How to make text change to certain records in databases?

GB44 · December 6, 2020, 9:57pm

I have some Posts that have an Action property (text field) that includes 2 spaces.

I need to update all Posts where Action property includes 2 spaces and replace the 2 spaces with a single space.

I could do it it in SQL. How do I do it in Bubble?

filipe.silva · December 7, 2020, 5:53pm

I’m not an expert but I did something similar using an API workflow.

If you select Data > App Data there will be an option named “Bulk”. It will open a popup allowing you to select a workflow.

You can create a workflow (private) that can execute for each database entry and clear the double empty spaces (find and replace function).

Then you can run the workflow for the Type you need and it will run for each entry

GB44 · December 7, 2020, 6:53pm

Thanks! This worked.