Best Of

In Domo, there isn’t a direct out-of-the-box bulk edit feature to replace a specific value or column used in multiple existing cards across different datasets or views all at once. However, here are some practical approaches you can consider:

1. Use a Data Pipeline or ETL Approach
If possible, modify the underlying datasets or views so that the “Old Revenue” column is replaced or aliased by “New Revenue” at the data preparation layer (for example, in Magic ETL or a SQL transform). With this approach, the cards referencing “Old Revenue” will automatically reflect the updated values without needing to update each card individually, as long as the column name remains the same.

2. Duplicate and Update Datasets with Column Aliasing
You can create a new dataset or view that renames “New Revenue” to “Old Revenue” (matching the column name expected by the cards). Then, you can switch the cards to use the new dataset. This method reduces card-level changes, though it does require managing the new dataset.

3. Card-by-Card Update
If modifying the datasets isn’t feasible (e.g., due to dataset structure or dependencies), you would need to manually update each pivot table card to replace “Old Revenue” with “New Revenue.” To speed up this process, you could group cards by dataset and open multiple cards in different browser tabs for editing.

4. Use the Domo API for Automation (Advanced)
If you have access to development resources, Domo’s REST API allows you to automate card updates programmatically. This would involve:
1. Listing all pivot table cards,
2. Retrieving each card’s configuration,
3. Updating the JSON configuration to replace “Old Revenue” with “New Revenue,” and
4. Pushing the updated configuration back to Domo.
This is the only true bulk update method, but it requires programming knowledge and careful testing.

Summary:
-There is no built-in bulk replace for card fields.
-Updating at the data prep level is the most efficient non-API solution.
-Otherwise, manual edits or API-based automation are needed.