Forum Documentation Showcase Pricing Learn more

Export to CSV workflow, can I not change related objects fields from "unique_id"?

I posted this before but didn’t get any replies so wanted to try again as it’s something we need to work. If I have for example a “Leads” object, it then has a few look up fields, like “Assigned To” and “Sales Rep” which are User fields where you select a Bubble user from the drop down and it shows their full name on the layout.

The problem is that when I export to CSV using Workflow all Leads, all the User lookup fields just show the users unique ID. For the created by it does this also but then adds a “Created by - Email” and shows that there. Is there no way to have the other lookup values show the same?

It’s similar if you have an Accounts object, relating to multiple Contacts. On the Contact you select the Account, but when you export the Contacts to CSV, the Account column shows the bubble unique ID vs the Account Name.

Is there a way to make this work?

Hi @lmoreau,
Use “Define primary display fields” to change the primary field of the table to anyother primary fields on that table like Account name.

App editor -> Data -> App Data -> Primary Fields (popup will show to change the primary field of the each table.)

Just getting around to trying this now but it doesn’t work. I already have all my primary fields set there but it doesn’t work on CSV export, only if I export to CSV from the bubble editor. If I use a Workflow with a button that says export to CSV it doesn’t.

image

See user above, I have it set to show email as the primary field.

Yet on a CSV export it just shows their ID:

Same with Company, the primary field is set to Company Name:

image

Yet the CSV shows:

image

Hi,

try to use othe csv export options available on Plugins.
otherwise please share the app editor, will check and get back to you.