2017-02-04

Hi @jason1!

Someone smarter than me might have a Bubble-only solution, but moving text to a number field in bulk is tricky, so here's one path you could take. Export your data to CSV > remove the $ with an Excel or Google Sheet function > upload the file and map the column to a number field. You won't be able to modify existing records, so these would be new entries in your database (which you could get rid of later), so each number would need some kind of identifier to map back to your existing records (catalog item id?)

Upload them to a temporary data type with 2 fields: number field for the numbers, catalog field to map to the item id

After uploading, create a workflow off a button click: make a change to a list of catalog items > new number field = search for temporary data type: first item's number, with constraint on the search: catalog item = this catalog item

I'd run this on a small sample to try it out first, but in theory, this should work. Also, I guess I should mention that if you're still in development and don't have a problem with just overwriting your data with the CSV upload, you can skip the whole workflow part. Just export > make the fix in a spreadsheet application > upload.

Gaby | Coaching Bubble

Show more