I have been trying to figure this out for day...

Kim_Coffman · 03-12-2018 05:00 PM

I have been trying to figure this out for days (embarassingly).

Table A (Events table), contains 3 columns:

.

Table B (New User Signup) prompts the user to provide the date they attended one of our events . After the user enters a value for I need the system to return the corresponding

from Table A that occurred on the

date the user provided. (ENUMLIST), so they can choose one or more of the events that they attended on the day they entered.

Seems so simple.

How do I do it? Kim

RezaRaoofi

You will need to query the events inside Valid_if property of the EnumList.

However if each user cab sign up in more than one event, then EnumList doesn’t seem to be the best solution.

I would add a third table for enrollment. That table would have Ref columns to Users and Events tables.

Grant_Stead

You can try this… Column Type: enumlist base type : REF and in the basetype qualifier: {“ReferencedTableName”:“tablename”, “ReferencedType”:“Text”}

Then your still need to create your date filter in the valid if…

Belinda

What field/where is the “base type qualifier”?

Grant_Stead

This post was from 2018.
The base type is no longer available. I’m sure Mr @praveen and @Adam are working on making this legit.

Grant_Stead

@Belinda This appears live in my account.

Grant_Stead

FILTER(eventtable, [eventdate] = [_THISROW].[EVENTDATEATTENDED])

Kim_Coffman

ok, I’ll give it a try, thank you!!

Kim_Coffman

That was it!! Thanks again!

Grant_Stead

@Kim_Coffman so, it works?

Adam-google

This property will be exposed again within the next few days. This time it will actually be a dropdown from which you can select the referenced table. @Grant_Stead @Belinda

Grant_Stead

Dang, Ya’ll are in a “hook Grant up with all the features he ever asked for mode!”
Appreciate you!

hru

Hi @Adam, I was following along the video attached to the help article below, and could not see the option to change an EnumInputMode type qualifier as shown by @tony.

This is the help article:

This is the snapshot of the video in the help article:

Than I look for the same question about it which is this post.

Is this EnumInputMode to change a text type to dropdown is no longer available?