Hi all. I have created a form for entering da...

(Will Badel) #1

Hi all. I have created a form for entering data and also have a view to read that data within the same app.

Is there a way to merge or combine data which carries the same name? ie two entries for me (Will Badel) will show in the app as one Will Badel with multiple records

Once again your help is always appreciated. Thank you

(Aleksi Alkio) #2

You can’t merge two records but you can create two tables… parent and child. Your personal data is the parent and records like child records. Then you can have as many records as you need for yourself.

help.appsheet.com - References Between Tables References Between Tables help.appsheet.com

(Will Badel) #3

Thanks aleksi. If I can’t merge what about grouping by name? Eg two records with the same athlete name group into one name with multiple rows of data?

(Aleksi Alkio) #4

That would work

(Will Badel) #5

Ok, so what expression or rule would execute that?

(Aleksi Alkio) #6

You don’t need any expression. You can group them inside the table view. If you open the table definition, you will see an option “Group by”.