How to create relationship between tables in database

krenkel · 2024-11-28T15:51:49.677Z

Boa tarde @annick-boisset , espero encontrá-lo bem. Vou te dizer que passei por isso tambem la em meu inicio, tanto que mandei mensagems para o suporte Bubble para eles verificarem o porque não aparecia os dados entre duas tabelas as quais eu tinha usuario e chamados, pois eu tinha um projeto de abertura de chamados em T.I. e tambem parei nessa situção de duas tabelas, a qual eu nao sabia como que eu faria para ter o usuario dentro de cadastro de chamados, foi ai que descobri que por exemplo na tabela usuario, nao preciso fazer nada, ela vai receber e salvar o usuario da forma normal, o que muda é na tabela refeicao que vai precisar ter um campo usuario do tipo da sua tabela usuario. e ai no cadastro da refeicao vocÊ vai colocar um dropdown apontando para sua tabela usuario, e ai sim vc vai ter a lista de usuario para selecionar na parte da refeicao e ai vc vai salvar com esse campo preenchido na tablea refeicao. Mas no Bubble ele trata diferente chave estrangeira a qual nos fizemos, pois apesar de nós acharmos que ele esta salvando duas vezes, o campo sera salvo na tabela que vc quer, mas nao estará duplicado e sim ele será vinculado a um ID da tabela usuario, só pra vc entender como é complexo o fluxo por tras do bubble para ele deixar mais facil para eu que sou leigo e iniciante. Não sei se vc esta me entendendo, vou te mandar um print. agora sim , caso voce tenha um terceiro cadastro e precise buscar dados da tabela refeicao, agora vc vai apontar diretamente a ela.

refe01377×171 7.14 KB

refe02698×332 19.5 KB

refe03790×445 17.9 KB

annick-boisset · 2024-11-28T16:52:28.197Z

Muito obrigada por essas explicações! Acho que configurei bem os dados (veja minha captura de tela), mas quando tento chamar a informação, ela não aparece… E quando olho o campo “idioma” na minha tabela “refeição”, ele está vazio. Estou pensando que talvez seja por isso? Aqui está como estou chamando o dado: current page’s table_repas’s langues’s langues …mas nenhum dado aparece.

image506×519 8.91 KB

annick-boisset · 2024-11-28T16:52:47.690Z

image494×388 7.3 KB

krenkel · 2024-11-28T20:48:45.261Z

Okay, now your repas table is correct, but to show, for example, the user data on the page you need, you need to have someone who searches for this data from the source table, for example. On page 2, you have a dropdown that will point to the user table. And there on page 2, you will have a save button. At this point in the data flow, from this save button, you will save to the repas table. I don’t know if I’m being clear with this explanation.

annick-boisset · 2024-11-29T07:58:54.675Z

Muito obrigado @krenkel , seria possível fazer uma videochamada com compartilhamento de tela para eu te mostrar o resultado? Porque alguém está realmente buscando os dados e eu envio as informações para a página, mas são os dados da tabela repas e não do usuário! Estou tendo dificuldades há uma semana com esse ponto e não encontro a solução!! Mais uma vez, obrigado pela sua paciência e ajuda.

krenkel · 2024-11-30T12:42:28.442Z

Hi, @annick-boisset, could you send a print of your workflow on the page where you want the data to appear, and show a print of your screen that will call this data?

annick-boisset · 2024-12-01T11:27:41.016Z

Hi @krenkel Here below is the capture of the workflow that sends the data to the page. Then, you will find the screen of the data and how I call it. That’s three screenshots!

image517×504 20.2 KB

image423×138 7.53 KB

image380×146 3.76 KB

The first name data doesn’t appear even though I’m correctly sending it to the user table. I don’t understand why it’s not working!

krenkel · 2024-12-01T19:13:41.626Z

Hi, @annick-boisset, you need to send the data to another page but it is not allowing it through the option to send data from the current page (you need to select the box (checkbox), try leaving the box selected and I will send it to you as an attachment in the print.

sel_send587×520 38.4 KB

And I ask you to read the topic related to this in the Bubble manual, here is a link for study and testing.
Navigation | Bubble Docs

annick-boisset · 2024-12-02T11:20:12.924Z

@krenkel Thanks again for the time… I just checked the box, but it doesn’t change anything… the data from my meal table is displayed, but nothing with the link to the User table.

salemmo409 · 2024-12-02T16:02:13.265Z

What workflow adds the user to the “langues” Field in the “Taple_repas” Datatype? and how you display this field in the UI?

annick-boisset · 2024-12-02T17:03:15.922Z

@salemmo409 Hi Salem and thanks for your help! Here is the translation of your information into English:

To save my “langues” field in the User table, I have a workflow: make changes to user → langues = input langues’s value, which works. In my User table, the language appears, and in my “Repas” table, I have a “langues” field of type User. In the UI, to call the data, I used: current page’s table repas’s langue’s langue’s, but it remains empty! Thank you for your help.

salemmo409 · 2024-12-03T07:26:50.723Z

I meant what workflow fills the “langues” field in the “Taple_repas” taple?

annick-boisset · 2024-12-03T07:39:43.695Z

So I don’t have a workflow for the dining table to call the data since the data is in User. I thought it would be enough to call the data once for one table, and that linking the tables together would give access to the data from the other tables. Is that not the case?

salemmo409 · 2024-12-03T08:05:34.370Z

You need to be sure that the “langues” field in the “Taple_repas” table is not empty, so you have to have a workflow that fills this field with the related user

annick-boisset · 2024-12-03T10:50:31.291Z

Hi, indeed in my table ‘Repas,’ if I look at the ‘Prénom’ field, it is empty. What type of workflow should I set up so that ‘Prénom’ gets filled with the data recorded in the User table? Thank you very much!!

ahmed.elkaffas · 2024-12-03T15:37:48.357Z

I assume that your table “Meal” stores all the meals ordered by a specific “User”. In this case, you need to add the user always to the “Meal” table as it won’t get populated automatically even though it’s the 2 tables are linked together.
I guess in your application each user orders a “Meal” then saves it; in this case please always add “Current User” to the “Langues” field of your “Meal” table when the user clicks “Save” on ordering a “Meal”.

annick-boisset:

What type of workflow should I set up so that ‘Prénom’ gets filled with the data recorded in the User table?

If I understand correctly, I believe you should always add “Current User’s Prénom” in your table “Repas”.

Hope this helps !

annick-boisset · 2024-12-04T07:46:25.741Z

@ahmed.elkaffas thanks a lot Ahmed, I will try to do that tonigh

annick-boisset · 2024-12-04T15:39:41.211Z

@ahmed.elkaffas So I just tried, but if I put the current user’s first name, it shows the first name of the user who is searching for the meal. I would like it to display the first name of the person who is offering the meal!

ahmed.elkaffas · 2024-12-04T16:07:14.955Z

@annick-boisset In this case, if it’s stored in the “Meal” table then use it, if not then “Do a Search for:first item” the person who is offering the meal

annick-boisset · 2024-12-27T13:58:12.849Z

Thanks a lot all is ok now!