Change values in an existing field in a table to all lower case

[RossChevalier]

I know how to force case in a Submission form, but I have inherited a bunch of records where this was not done and am seeking a way to read a field in a table and convert the contents to all lower case without a lot of manual work.

Any suggestions?

Thank you kindly!

[kpcollier]

Could probably do something like below. 

Obviously, instead of BidTable use the table you need to edit. And, instead of BidName, use the field that you need to be changed. Just make that field equal itself, while inside the lowercase block.

The WHERE clause is because I'm not sure how many records are in your table. There is a 10,000 Max # of Affected Records limit for tasks and triggers. So, if you have more than that, you will need to break this down into multiple parts. Hopefully your table has an ID, if not, they are easy to add and delete afterwards if you need. Once you run the first task, change the ID values in the WHERE clause to '9999' to '19998', and so on. I usually like to do 9,000 intervals.

[kpcollier]

I would duplicate your table and try it on that before you use it on your live table. I haven't tested the above.

[cheonsa]

Just to add in the previous comment, what you need to create is an Application Tasks. Tasks are ideal when you want to batch process large volumes of data.

Here's the article for more details about it: https://howto.caspio.com/tasks/

[Wikiwi]

If your account doesn't have triggered action or task (explore plan) what I can suggest is to create a new field on on your table, set its DataType to Formula and use Lower([field]), and convert that new field again to text once done . This is a lot laborious than using task but account with lower subscription plan can use this as an option.

[Flowers4Algernon]

Hello, maybe this could help as well: