Need help putting in data from database to a text

Hello Guys, I am in a situation where I cant get to the solution myself. I tried googling online and different ways.

In my database i have the datatype “BMI” which has the fields “Weight”, “Height” and “Date” and “Age”. Through my button “Calculate” i calculate the BMI and it is saved in my database. Here is the button “code”:

Then I wanted to show this data into a text-field which i put into a group. It should show the current data which was inserted, but also the data which was already submitted a time ago.

I tried it with
image
(Search for BMI: first item’s age)
but this didnt quite work well.

Does anyone know a solution for this? Im only a beginner and the solution surely isnt that complicated, but I just cannot solve it alone at the current moment. I apprechiate your help very much!

1 Like

Do you want to show the trend?
Or do you want to merge the data?

For the process, you can use repeating group or format as text

You should explain more for merge.

1 Like

If you want to display multiple BMI’s for the same user you need to use a Repeating Group of the data type BMI, and the data source would be a “search for BMI, where BMI creator = current user”.

2 Likes

My teacher wants me to display height, weight, age and data, so that the user can change for example the high from 150 to 130 on 01.01.2023 if he wants or that the user can change the age or the data

Hello! I would like to show the height, weight, age and date from the calculation. For example the user typed in 120cm height, 50kg weight, is 18 years old and the date is 01.01.2023. The user should be able to see the data and then change or delete it. So the user should be able to, for example, change the 120cm height to 150cm height if he wants to.

1 Like

Repeating Groups should be utilized in this scenario.

2 Likes

Thank you, I use “Repeating Group” but I still don’t know what kind of dynamic data I have to put in. (Search for BMI: first item’s age) doesnt work and I can’t think of some other solution

1 Like

No, there is no need to select the first one, they accept a list of items.

The video tutorial can guide you better. (Use play icon)

2 Likes

Thank you very much for your help, it works perfectly now :slight_smile:

1 Like

You’re welcome. Good luck :dizzy:

1 Like

This topic was automatically closed after 70 days. New replies are no longer allowed.