Linking from cells in table and Embedding in Website

Help & Support 💻
1

Hi,

Newbie to UI Bakery here. I am building a directory style app which is powered by a MySql database. Before I start down the UIB rabbit hole, I have 2 requirements that I would like to know if they are possible.

  1. I am displaying the data in a table and would like to be able to link from the cells (not the row) in the table to another table and at the same time passing the data along for the subsequent search.

e.g.

Name | Vehicle | Driver Class

John Browne | Ford Focus | R5

The name, vehicle and class are all stored in tables and carry an ID as the primary key.

When the user clicks John Browne, the driver id should be passed to a search on the drivers table for that id. The resulting table would show John Browne’s information and driving history.

Likewise if Ford Focus or R5 is clicked.

In PHP, each cell would have the id as a hidden parameter and this would be passed in the URL call to the next page/query.

Is this possible in UIB?

  1. Is is possible to embed my app on to my website?

Thanks
Steve

2

Hey @SynopsisLabs, welcome to UIBakery!

What you are asking is possible to do.
The first one requires a bit of a setup, but should be not too difficult. If I think about how I’d do it, it would be similar to they way you describe it. Either load all the data in with apropiate IDs in their fields, that then will be passed on click or just get the IDs on the fly. Anyway, there’s multiple ways to do this, in the end it depends on performance, simplicity and amount of data.

Also embedding is possible, but only with the on-prem version of UIBakery. You can read more on it here:

3

Hi @Max,

Thanks for the info. The second point is a deal breaker as I am not particularly interested in self hosting. Am trying to cut down on resources need to build and keep my website up and running.

Steve

1 Like