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

[Will_Badel]

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]

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]

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]

That would work

[Will_Badel]

Ok, so what expression or rule would execute that?

[Aleksi_Alkio]

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”.