2 values can input in 1 field?

[Bernie_Jay_Manalo]

Hi everyone, may I ask if we could put 2 values in 1 field, if not please recommend me what to do, all recommendations are appreciated. Here in image attached once the Group ID is selected all of its members in a group will auto display in a field, since this view is in “Grades“ I wanted that it will display name in not editable and can also put a score in it. This is the final structure “Britney - 92”.

[JhunePol]

If you want the result to be “Britney - 92” and the member is not editable. You will need another physical column to put a score for every member. Let’s say, Score 1, Score 2, Score 3..Meaning Score 1 is for Member 1 and so on..In the form, you can display the column Score 1 after the Member 1.

Then Uncheck the Editable? for the Member 1, Member 2, Member 3, etc…

Create a virtual column Name 1, Name 2, Name 3, etc. For Member 1, put the formula CONCATENATE([Member 1], " - ", [Score 1]), then show it on your table, and hide your Member 1 column and Score 1 column in your table.

[WillowMobileSys]

The best option here is to take advantage of AppSheets internal Parent/Child relationships. You can show your Members for the group in a table, displayed inline, and in that table include any additional columns of information you wish to show.

To create this I would suggest at least 3 tables -

1. Groups - that hold all group specific details
2. Members - that holds all Member specific details
3. GroupMembers - holds details specific for that Member in that Group such as grade/score and ALSO this table allows for that member to be included in any number of Groups

The Group table is the parent. The GroupMembers table is the child and includes a “Group” column and a “Member” column to “connect” to those tables.

The “Group” column would have the “Is part of” property turned on. This automatically creates a “Related GroupMembers” list in the Group table and when added to a Group Form view, will automatically display as an inline table. See image below

I hope this helps!!

[Bernie_Jay_Manalo]

Thank you so much Brother

[Bernie_Jay_Manalo]

Thank you brother, this is such a big help