Hello bubblers!
I am building an app where users can save information by filling up a form. How can I save all the form information into a unique data base?
Thank you all!!
Did you do the lessons?
Have a look here:
https://vimeo.com/66072019
1 Like
Hey Vincent, thank you very much for the video! It solved most part of my doubt.
In the first section of the form there are some information that come from other data base, I mean, when the user choose the “Nome” (name) the fields “Função and Empresa” will get the information from other data base. So, when I am building the workflow I don’t see these items in order to select them. The same happens with the field “Data e hora” which is not coming from any data base.
I think i have to use the option “do a search for” but I don’t know how to use.
I’ve been watching several videos but did not find one which talks about this issue.
Could you please help me with this?
Thank you in advance!
You mean Função and Empresa are dependent on Nome? So when you select Nome, the Funcao and Empresa changes automatically to values that belong to that Nome?
In this case you need:
Data type: Função
Field: ‘name’ (text)
Field: ‘Nome’ (of thing ‘Nome’)
data type: Empresa
Field: ‘name’ (text)
Field: ‘Nome’ (of thing ‘Nome’)
Data type Nome
Field: name (text)
Then in the form you do this:
Field Função: Do a search for Função first item’s name, constraint: Nome= dropdown Nome’s value
Field Empresa: Do a search for Empresa first item’s name, constraint: Nome= dropdown Nome’s value
But you could also create:
Data type Nome
Field: name (text)
Field: Função (text)
Field: Empresa (text)
Then in the form you will have:
Field Função: dropdown Nome’s value’s Funcao
Field Empresa: dropdown Nome’s value’s Empresa
It all depends on the relationships you want these things to have and how complicated these Things will be but there are multiple ways of achieving this.
If Empresa will have additional fields, then it makes sense to create a new data type out of it. If it is just one field, you could put it all in one ‘Nome’ data type.
Maybe the best thing is to first put this all in an Excel table, that will give you an idea of how to convert it to Bubble databases.
1 Like
Thanks for the hand buddy!
So, the fields “Nome, Função and Empresa” must be in a separate data type because a specific user will add and modify this information everyday. So the final user which will fill up the form needs only to choose his name and, in order to avoid filling mistake, the fields “Função and Empresa” be populated automatically.
These information are appearing accordingly but I did not find a way to save this information in just one data base.
This is the data base which I will put all the user information (which will appear when user choose the his Name on field “nome”)
and this is the data base which will be used to store the info from the form.
But the form will use info from the first data base to store on the second data base. Do you know what I mean?
So I’ve created the workflow and added all the forms but I could not find a way to include the info coming from the first data base (POB) to be saved on the second data base (OBS Card List) when I click in “Salvar” (save button)
By adding a field of POB of type ‘POB’ into the OBS card list database. That way the POB and OBS are connected.
Ok, I did it but how can I associate to the two fields (Função and Empresa)? I am lost on this… sorry
You don’t have to associate every field with another, just associatr the things that way you can always reference a things thing.
Not sure what you want to achieve with these fields?
I need to save these info (which come from “POB” data base) on “OBS card list” data base when the user clicks on Save button (on the form).
I’ve added the field “POB” into the “OBS card list” database but I need to extract two specific fields from the “POB” data base. I am stuck on this step.
Which parameters do I have to add to refer to these specific info from the POB data base?
Ok so what about adding those Empresa and Funcao fields to the OBS car list data type, either as text or of type POB.
If it needs to be simple, you can just save Funcao: 'dropdown nome’s POB’s Funcao.
So you need to refer to the POB that was selected when you selected a nome from the dropdown.
But you can also just store the POB from the nome dropdown into the OBS data type. This way you don’t have the exact field in the thing, but you have access to all the fields from the POB that was selected (and added to the OBS thing).
It all depends on how you need to work with this data from that point.
Unless you need to have it all on the same ‘level’, the data can very well be living inside another thing. But as long as they are connected that way, you can always refer to it. So it is like you store all the fields of POB onto the OBS thing but all in the form of one field of thing POB. Otherwise you are duplicating information where you may not need to. Another factor to consider is, does the data need to be static or dynamic? Like a snapshot in time (which will be a field of Funcao as text) or a live connection to the POB (Funcao as type of POB). This way, when you change information in the POB database, it will get reflected on the OBS Funcao too.
Maybe it helps to explain what the next thing is you want to do with the data?
1 Like
Thanks for the help Vincent!
Now it is working perfectly!! Thank you very much!
No I got a doubt on this item, can you help me?
Cheers!
This topic was automatically closed after 70 days. New replies are no longer allowed.