Very basic question:
Without creating a workflow, how can I create a new database entry from the data tab, and populate fields that reference other tables (eg. the non-text, non-number, non-list, etc… fields?)
For example, I want to populate the “user” field with the user$unique_id. Is there a way to do this without creating a workflow?
Hey @kramwe 
Yes, you can copy+paste the unique ID into that input and it should display as an option to select from a dropdown, then save.
Alternatively, you can click “change search field” and select ‘email’. Then start to type in the User’s email that you’d like to link to that entry, select it from the dropdown, and click save. It’s the equivalent to Making Changes to a Thing without the workflow.
I’ve never seen that… can you please share a screenshot.
Sure 
If you have a Product Thing you are trying to modify, by adding to its User field, you would click “change search field”:
Once you click that, this will appear:
Here, the default search field for User is Unique ID. Click the dropdown to change this to “email” (or anything you choose that makes it easy to lookup a User. This could be first name, last name, etc.)
I selected “email” then hit Save:
Back in the Product popup shown in the first screenshot, I can type in a User’s email and click save to store that User value to the User field:
Once that is saved, the User is now stored on the Product I was trying to modify. Since we changed the ‘primary field’ for the User, the database view now shows the User’s email in each row applicable, instead of the User Unique ID:
Thanks for sharing @fayewatson!
Do you know whether this change impacts the way our app works/joins tables for the user facing portion of our app, or is this simply a change in how it’s viewed in the Bubble admin panel?
Thanks,
Scott
No problem at all! Right, this is only for making it easier to modify and display data in the admin panel. I change these frequently and haven’t noticed any changes to live data or the way the app works.
Very helpful! Thanks Faye! --> change the search, now it populates. Win.
