UI Builder table relation

Backendless on Windows
1

I need guidance to make the relationship between tables in UI Builder. I want to bring data in a form from the relationship between the tables. Can you help me?

2

Hello,

Let’s add more details. For example, please specify:

  1. Names of the tables
  2. Name of the relation column
  3. What exactly should the form show? Use an example (possibly with screenshots) referencing table data.

Regards,
Mark

3

Hello
I have two tables:

  1. “Street” with the fields: ‘name’, ‘neighborhood’, ‘area’
  2. “neighborhood” with the fields: ‘name’, ‘area’
    I want that when I want to create a new street object and reach the “neighborhood” field in the form to display (with autocomplete) the list of available neighborhoods to select them, and after I have selected them to bring me the “area” the neighborhood selected in the field ‘area’ in the form of streets. Of course I can save them in the ‘streets’ table
    Thanks for your help
    Regards,
    Horea
4

Hi Horea,

This is a great question. Let me put together a quick example and I will share the details. It should not take much time.

Cheers,
Mark

1 Like
5

:grinning: :innocent:

6

Here’s a little demo for you:
http://www.backendless.us/index.html?page=AddressForm

This is how it works:

Table Address:

Data Schema - ConsoleDemo - Backendless 2020-07-20 11-37-35
Data Schema - ConsoleDemo - Backendless 2020-07-20 11-37-35855×389 114 KB

Table Neighbourhood:

Data Schema - ConsoleDemo - Backendless 2020-07-20 11-38-11
Data Schema - ConsoleDemo - Backendless 2020-07-20 11-38-11770×359 85.9 KB

Populating the drop-down component with data:

UI Builder - ConsoleDemo - Backendless 2020-07-20 11-39-00
UI Builder - ConsoleDemo - Backendless 2020-07-20 11-39-001152×551 201 KB

Data binding for the Street Address input:
UI Builder - ConsoleDemo - Backendless 2020-07-20 11-39-49

Data binding for the Neighbourhood drop-down component:
UI Builder - ConsoleDemo - Backendless 2020-07-20 11-40-21

Now, here’s the logic for the button to save everything in the database:

UI Builder - ConsoleDemo - Backendless 2020-07-20 11-40-53
UI Builder - ConsoleDemo - Backendless 2020-07-20 11-40-531178×508 192 KB

Hope this helps!

Mark

1 Like
7

I don’t want to sound insensitive to you, but where is the “area” that I should take from the “neighborhood” to the street?
Thank you again