
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 31, 2020 05:13 PM
How would I go about adding a field to an existing table that already has 25,000 records and filling all 25,0000 cells in that new field with the same value, say, “Cookbooks?”
If you’re curious, it’s because my dear old dad put both general subject location data in the same cell with specific location information (i.e., Cookbooks - garage wire rack, top shelf). And before you go suggesting that I use a formula which divvies up the data before and after the dash, I should say that he’s totally inconsistent in the way he orders this information and the way he separates it.
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 31, 2020 05:17 PM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 31, 2020 05:17 PM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 02, 2020 09:21 AM
Use the batch update app as @ScottWorld suggested if the base is in a pro workspace. Otherwise use a formula like:
IF(FIND('Cookbook', {Field Name}), 'Cookbook')

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 02, 2020 09:35 AM
Oh right! Great idea from @Kamille_Parks! Then, after you create your formula, you can switch your formula field to any other type of a field, and your calculated value will remain intact.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 02, 2020 10:09 AM
The Batch Update worked wonderfully, ScottWorld. And I’m glad there’s an option for those who don’t have the pro version, Kamille_Parks. Thanks to you both! :slightly_smiling_face:
