I have an app where I want to display ChatGPT-generated output (which I’ve assigned a “Creative Output” data type) by the Project Name (which is “Project/Client Inputs” data type) in a repeating group. I’ve linked the two databases with a field I’ve called “Project Name Link.” Here’s how the nav button is populated to grab the “Project Name” info from the other data type:
The trouble is that the button remains blank unless I manually go in and search-and-enter the “Project Name” in the database. Here’s a screenshot of the nav, showing the first three projects where I manually entered the “Project Name Links” using a database search, but all the others are blank:
The reason the blank ones aren’t getting populated is pretty clear: they are not populated in my linked “Creative Output” database link field to “Project/Client Inputs.” Here’s a shot of a blank “Project Name Link” field within the database (It’s partially obscured by the search icon):
You can see the field is blank, but when I search it, I can populate it manually. When I’ve tried to populate it dynamically at the right spot in my app process using a “do a search for” the “Project Name” field in the “Project Client Inputs” type to establish the field link, I get a pesky red message like this:
I must be doing something wrong, or misunderstanding something about how related databases and their fields get linked. Can anyone help me get through this barrier?
As far as I see, Project Name Link is of type Project but Project Name is text. So you won’t be able to assign text to Project. It should probably be Search for Project/Client Inputss:last item only.
Thanks, Hergin! Great idea. I hadn’t thought to stop at “last item.” But it didn’t point it to the “Project Name” field. It just left the data blank.
I thought that by creating the “Project Name Link” association between the “Project/Client Inputs” data type and the “Creative Outputs,” I would open up a link to that type and through that relational connection (if that’s a term), pull the text data from “Project Name” (a type “Project/Client Input”) into a page where the data is of type “Creative Output.” Is that not possible?
The connection you think is happening when you create a field of type Project inside Project/Client Inputs. If you have this field, you can get Any Project/Client Inputs's Project's Project Name and any other field of the Project.
Right! If I’m understanding you correctly, I should be able to populate the field that links the “Creative Output” type with the “Project/Client Input” (called “Project Name Link”) with any field from “Project/Client Input” (in this case, “Project Name.”) But how do I point it at that specific field. By stopping at “:last item,” I’m just indicating a “thing,” (or row) so Bubble leaves it blank. I must be missing something. How do I point it to the specific “Project Name” field within that thing?
That’s how you create links. You stop at a thing, assign it to a field of same type, and the link is created. Maybe I am misunderstanding something in your question.
I’m just wording it badly. In addition to “Project Name,” multiple fields in the “Project/Client Input” type are text: there’s also “Company Name,” and “Department.” So how do I make sure the link that I want to call that field goes to the right field within the thing?
If you just want to get the name of the projects, you can change the type of Project Name Link to text and then you can assign ....'last item's Project Name. This should work fine as well if you just need project name from the Project/Client Inputs type. However, in this case, you just get it as a text and you won’t be able to access any other field.
Which kind of makes sense, since it’s only grabbing the last item over and over. The direct link might actually work, if I could get it to grab not one over and over, but all of those outputs produced by that user, and not just the last one.
