Multiple choice buttons based on ref

monedero
Participant II

I need to create a form to record attendance to sessions among a list of registered pupils. All their names displayed together with check boxes to mark their attendance. But the list of pupils must not be static. It needs to be the current list of pupils.

0 12 492
12 REPLIES 12

Aurelien
Participant V

Hi @monedero

Does the EnumList Type answer your question ?

monedero
Participant II

No, because it does not allow me multiple choice. I need to mark all pupils who attended the class.

thatโ€™s weird, I made a test and that works for me.
Can you please share a screenshot of your pupils table and your sessions table ?
You picked EnumList ?

monedero
Participant II

My screen doesnโ€™t show the field to specify the reference table name

When using a column of type Enum or EnumList, with a Base type of Ref:

  • The Allow other values setting must be on.

  • The Referenced table name option will not appear until the app config is saved. After saving, return to the column config and choose the desired table.

  • Unlike a column of type Ref, a column of type Enum or EnumList of Ref does not automatically provide the user with existing rows to choose from, so youโ€™ll need to provide a Valid If or Suggested values expression to provide that list of choices.

Thanks. I will test your solution

monedero
Participant II

I have tested. I have defined in the Sessions table, the [Related pupils" as enum list. It doesnโ€™t seem to work

It appears you added it as a virtual column. Virtual columns cannot be input columns. Youโ€™ll need to make it a normal (non-virtual) column.

It is a normal column. I have not used yet virtual columns

3X_4_a_4ab41635ef71b87b75d4cf26f8c2e59dc851fefe.png

Sorry, I realiza now that it is a virtual column but system generated. The problem is that I donโ€™t know how to create a non virtual column that contains several values for each record. Related asistentes is a list of all the persons who assisted to that session.

Create a column of type EnumList as I described above.

Top Labels in this Space