Replace all of one thing with a new thing

I have built an app that does what it needs to do. However I have come across a problem with telephone numbers now I am adding data. As such I need to change the field type from number to text. The only way I can see to do this is to delete the current field and replace it with a new one.

Is there another way, either to stop the telephone numbers from changing format, or to change the field type.

If not, is there a way I can update all instances of the current data field (that I will be deleting) with the new data field?

I had a look around the forum to see if this was answered, but I couldn’t find anything obvious.

@clubpro You can use an API Workflow to run this as a batch process. You’ll need to be on a paid plan to use API Workflows, but essentially:

  1. Create an endpoint with a parameter for the Thing (single value, not list)
  2. Add an action to make a change to [parameter’s value] (i.e. the Thing)
  3. New field = This thing’s old field

Now go to Data > App Data > Thing’s table > Bulk > Select the endpoint you created and run it on all of the Things

Done!

If you’ve never worked with API Endpoints before, watch this to learn how to enable: https://www.youtube.com/watch?v=RbQCCZfdzes


Gaby at Coaching No Code Apps (formerly Coaching Bubble)

Courses & Products, Tutorials, Private Coaching, and High-level Development

Start Learning Today :mortar_board:

1 Like