Want to build page from database data

From what I’ve read, there is no way to automatically create a new page as an action in a workflow. Is this correct?

If there’s not a way, that’s ok. I’ll create the pages manually. However, I’m hoping the page can be built with data from the database.

Here’s where I’m at…

We have a user who submits a request - a simple form collecting email address and some text. That request is assigned a 4 digit ID number in the submit workflow. Based on the email address, we will add other values into the database (name, phone, state, request title (based on the text they provide), due date, etc).

A new page will be manually created (if it can’t be done automatically) and the page name will be the 4 digit ID, i.e. 1234. So the url would be myapp.com/1234 that users will go to.

Can I display data from the database onto the page, based on the page title (1234)?

The page will have a headline that says something like “Here is request #:” and then, under the headline, it will have the 4 digit ID and request title, due date, state.

So it would be:
Here is request #:
1234
Request Title
Due Date: 12/12/21
Located in: California

If I have to manually create the page and manually set the request number, can at least the request title, due date, and state be displayed based on the manual request number?

Thanks!

1 Like

myapp.com/1234

You can’t do it with a URL structure like that, but you can do it by creating a page such as http://myapp.com/request and then dynamically and automatically created new pages for entries from the database such as http://myapp.com/request/1234, http://myapp.com/request/5678 etc.

Then you can dynamically pull the data for each request onto the page.

Thanks, Adam.

Do you have a link that documents how to dynamically and automatically create these new pages?

Also, from what I’ve been reading, if I want a page to be myapp.com/1234 I will need to use some sort of plugin? The URL will be sent on postcards and will need to be short, ideally myapp.com/1234 (my domain name is a short url for this reason).

As long as you define a ‘content type’ for a page then pages are automatically created for each database entry. So whenever you create a new ‘Request’ database entry, a new page will be created, and can be accessed using either the entry’s unique ID, or the entry’s ‘slug’ (if you’ve added one) as the URL path.

The Bubble manual is a good place to start to understand how to define content types and datasource on pages and elements, so take a look through it if need some clarification:

Displaying Data - Bubble Docs

1 Like

Thanks again, Adam. I really appreciate. Was able to get it to work!

1 Like