Company field in dynamic data

Hi folks,

Happy Easter (for those of you who celebrate Easter)!

Is anybody able to tell me what I can do to fix this?

I have a field called ‘Company page’, and its field type is set to ‘Company’. When someone fills out their profile for the first time, if they start typing in the name of a company that’s already in the database, it should auto-fill. The hope is that multiple people at the same company should all be recognised as such, and not at different companies depending on how they fill out that line of the form (e.g. Google vs. Google LLC). I know I could get around the problem I’m facing by simply setting the field type to ‘text’ instead of ‘company’, but that’s not what I want.

Thanks in advance for any assistance!

Hey @robin.wyatt

Happy Easter!!

To have values populated in a text box, you need to populate it with text.

My guess is that in your data type “Company” there would be a field like CompanyName that would be a text field and that has the name of the company in it. Or something like that?

At the moment you are just referencing the entire company record for that user’s company, which could be a number of fields with all sorts of data in them. You need to click on the (more) part in red and select the field from that company record that you want to show - i.e. CompanyName


Josh @ Support Dept
Helping no-code founders get unstuck fast :rocket:save hours, & ship faster with an expert :man_technologist: on-demand

1 Like

Thanks, @josh24. I really appreciate your help! Your explanation helped me understand more about the way the database is structured, which in turn solved the problem.

1 Like

Always happy to help :slight_smile:


Josh @ Support Dept
Helping no-code founders get unstuck fast :rocket:save hours, & ship faster with an expert :man_technologist: on-demand

Hi again,

After reading @josh24’s explanation, I deleted my ‘Company page’ field from within my ‘User’ data type (which had the field type ‘Company’), and left my ‘Company’ field (with the field type ‘text’) as it was (also under my ‘User’ data type). I thought this had solved my problem, but I have noticed a couple of issues remain. One is that I see ‘Current Page User’s Company page - deleted’s Logo’ at the top of my users’ profile pages, as in the following screenshot:

Bubble is pulling from something I’ve deleted, which obviously isn’t ideal. At the frontend, I see that the logo is actually present. However, what I want to be able to type is this:

As you can see, it’s not an option that’s available to me, and I’m not sure why. This is how I have set up my database:

Company:

User:

I’m now wondering whether I misunderstood @josh24’s explanation, and that I should have left the ‘Company page’ field (with the field type ‘company’) intact under the ‘User’ data type (but probably renamed it to ‘Company’ and deleted the one called ‘Company’ (text)). If this is correct, is there a way to change my field type from ‘text’ to ‘company’? It looks like there is not, and I am unsure how to re-do this from scratch, given the footprint that seems to be left in place when database entries are supposedly ‘deleted’.

Your Company field on the User data type is not a Company… so you can’t reference a company from that (it’s just a text)…

You could do a search for companies, and then match it to the text field… but that’s not really the way to do it…,

You want to have a Company field in the User data type.

So delete the existing text field, and replace it with a company field.

1 Like

Many thanks indeed! This solved it.

1 Like