Hi, Guys:
New problem. I have a list of courses set up as enum in the column definition. The list of courses have been entered individually as Enum Values.
The list contains a mix of public and private courses.
Iโm using a form view to add participants to the courses. However, I only want the public courses to appear in the dropdown list of courses (so that random people arenโt accidentally added to a private course). It doesnโt look like a filtered slice is working.
I also tried a formatting rule to strikethrough the private courses, but Iโm guessing the enum list overrides all of this.
How can I filter out the private courses and only show the public courses in the formโs dropdown list? Can it be done?
I canโt use a dependent dropdown because I donโt have another field to refer to (since the public/private column is populated by the course via LOOKUP).
@Jayne_Hawkins So from what I understand, you have a column that defines if the course is public or private? If thatโs true, you can just edit the column youโre using for the dropdown list. When you go to โEdit Column Definitionโ, make sure your column type is set to Enum and set EnumInputMode to โDropdownโ. Then, modify the Valid_If expression to SELECT only rows whose public/private column is โpublicโ. E.g. SELECT([Course Name], [Public/Private] = โpublicโ). Modify that expression to fit your own data, but it should work.
Oh yeah, remove all the courses you inputted from the EnumValues, this Valid_If statement will populate for you.
+Jacob Lin I have two tables, Participants and Courses. Participants is where the actual form data goes. Courses is a pre-populated list of courses and details (time, date, location, etc).
The reason I manually entered the EnumValues was because the โcourseโ column of the Participants table is blank (until a form is submitted of course). Once the user selects a course, most of the other fields in the Participants table are populated via LOOKUP (taking the information from the Courses table, such as date, time, etc.). One of the LOOKUP columns is Public/Private - so the public/private status isnโt populated until after the course has been chosen. Cart before the horse, as they say. With the way itโs currently set up, if I remove the EnumValues, that will leave me with no courses in the dropdown, correct?
See attached image. What I really need is for the โCourseโ dropdown options to come from the Courses tableโฆ but I need the City, Venue, Date, etc. to be looked up and populated into the Participants table. I canโt find a way to populate that one โCourseโ dropdown field from the other table.
I donโt think populating the dropdown with courses from the Participants tab will work (unless theyโre manually entered as EnumValues, like Iโve done) because the only courses that appear on that list are courses for which someone has already registered. I need to draw from the full list of courses on the Courses table.
Make sense?
@Jayne_Hawkins Ok, so what this boils down to is retrieving data from a second table to put into your Course dropdown, based on the โpublicโ column in your second table? Iโm again assuming that your โpublicโ column is an actual column in your Courses table.
Try this in Valid_If of Course dropdown: SELECT(Courses[Name], [Public] = โpublicโ)
Replace โCourses[Name]โ with the column that you want the enum to make a list of, Iโm just guessing that youโd want the course name.
Youโll have to remove the manually entered Enum Values. Manually entering them when
you want to base their selection off another column will never work.
@Jayne_Hawkins Remove the Enum values from the [Course] column of the Participants table, change its type to Ref and set the ReferencedTable property to Courses, and add a Valid_If expression that draws in the appropriate courses from the Courses table:
=filter(Courses, in([Public/Private], list(โPublicโ)))
Then, in the other columns in Participants you want auto-filled from the course information, set the App formula for (e.g.) the [City] column to to something like:
=[Course].[City]
+Jacob Lin & +Steve Coile - YESSSSSSSSSSS. Exactly what Iโm trying to do (both explanations)! Thanks!!
User | Count |
---|---|
40 | |
29 | |
22 | |
20 | |
15 |