Im clearly missing something. In the workflow I am referring to another dropdown, as I have a number of times, even within this flow and it wont go blue. I have even deleted the dropdown and tried again. The field in the DB is text, Ive double checked.
Im sure it obvious to others but can someone point it out please.
Hi there, you asked the exact same thing over here, which I answered here:
If the âSupplierâ field on a Batch Ingredient is indeet a Supplier, than you wouldnât need the additional âSupplier Nameâ at the end of the expression.
Forgot. Im getting pretty confused with this at the moment. I sat down with Figma today and mapped out the part Im working on to try and help
I took off the extra supplier name and it didnt help. I did go and clear out all the issues. I cant remember what issue was by memory I could understand. Im getting lots of errors because Im replicating the same info 60 times and after the first replication it breaks. As I go along I fix them
The heart of the matter youâre trying to fix here (i.e. âExpression wonât go blueâ) is the datatype of the dropdown (âSupplier Listâ) needs to match the datatype you are trying to set in your Batch Ingredient. What datatype is âSupplierâ in your Batch Ingredient data?
Ive looked really hard at everything, everything is text. The only thing that is I cant see how to tell what datatype dropdowns are or where to change them so I would assume they are text by default as they are the same as everywhere else.
The only difference with this dropdown is I have a static list in a dropdown of all the countries in the world that I use to filter by. Im using a static list as it was a simple copy paste. I dont know if that is causing an issue.
In your screenshot, you show that you have the dropdown datatype set to type âSupplier Listâ - so that would be what datatype youâd be referencing if youâre pulling from that.
The âblueâ dynamic expressions youâre attempting to get into nested territory, where youâre referring to a âThingâs thingâ, for example, a Dropdownâs Supplier Listâs Company Name; the important thing is the data youâre referencing matches the data youâre setting. If you include a screenshot of how your database is setup, especially Batch Ingredient, and Supplier List, that would be helpful.
Am I crazy or are you looking for a single entry in that filed but your data expression is producing a list? I see âeach items nameâ where you need âthis items nameâ?
Hi,
From as far as I can see its set up the same as all the others
Heres some screen shots
I doubt Im well set up, this is like the first real app Ive worked on. I have a little experience with DBs but they have all been set up.
Hereâs your issue:
Bubble is a relational database; these relationships are built by linking datatypes.
On your Batch Ingredient, you have a field called Supplier, set to type âNumberâ. What this should instead be is a field called Supplier, set to type âSupplier Listâ. In Bubble you canât edit these datatypes once theyâre created, so instead youâd need to delete the Supplier field, and create the new Supplier field with the proper Supplier List datatype.
Some of the benefits of linking data this way is it forms a 2-way relationship with your data, allowing you to change a value in one datatype (letâs say if you had to change a Supplierâs name), those changes can be carried through the app.
Cheers mate, Ive been looking at supplier list and not ingredient. Thanks for sticking with me
Hereâs some more into on database relationships - about 60% down the page, âRelationshipsâ
This topic was automatically closed after 70 days. New replies are no longer allowed.
