Dependant Dropdowns

[David2]

I am currently trying to build functionality into a timesheet app where, on the form, a project is selected which enables another dropdown where a task, related to that project can be selected.

I’ve read a few articles on dependant dropdowns and tried modifying numerous snippets of code posted but have been unable to get anything to correctly work for me.

Basically, each project can have many tasks, at the moment each task can belong to multiple projects (HOWEVER, if this is an issue, I can change this to each task belongs to only one project) and each timesheet has only one project but can have multiple tasks related to that same project.

So I have three tables that relate to this, a Projects table where I have a text field called Project. I have a Tasks table, where I have a text field called Task and an Enumlist (Ref Base) called Related Project / s. Lastly I have a Table DDS (Dependant Dropdown Sample) where I have Project Worked On field and a Tasks Worked On field unsure of the column types required for this.

This article was great but didn’t quite answer my question;

help.appsheet.com

Dependent Dropdown

How to make a dropdown with choices that depend on the value selected in another dropdown.

This post was the closest scenario I could find, however despite all atempts, could not get this to work either.

How to make Dependent Dropdown in Forms with data from different Tables Questions

Hello I thought I would be able to nail this, but I can’t… So in a Task Management app, a Project has many Objects, and an Object has many Tasks (the project would be to make the furniture of a coworking, and an object would be to make a table, and a task would be to make the desk of the table). There is a Projects Table with a Project Name column There is an Objects table, with an Object Name column and a Project Column that references the Project Name column from the Projec…

Any help in trying to get the required column types for the DDS table and the Valid If Statment working would be greatly appreciated.

Thanks !

[Steve]

The Valid If for the Project Worked On column of the DDS table:

FILTER("Projects", TRUE)

The Valid If for the Tasks Worked On column of the DDS table:

FILTER("Tasks", IN([_THISROW].[Project], [Related Project / s]))

See also:

help.appsheet.com

FILTER()

Select rows of table or slice

help.appsheet.com

IN()

Is item in list?

help.appsheet.com

ORDERBY()

Sort row references

[David2]

Thanks @Steve, the valid if didn’t work be default for the Tasks Worked On column, however I changed it to this;

FILTER(“Tasks”, IN([_THISROW].[Projects Worked On], [Related Project / s]))

This doesn’t display any errors, however, the only issue now is that in the app, it displays the ID field not the Label field. Essentially just shows a string of characters.

I have attached a screenshot.

Thanks again!!

Screenshot 2020-12-16 193758|392x500

[Steve · Accepted solution]

David2:

This doesn’t display any errors, however, the only issue now is that in the app, it displays the ID field not the Label field. Essentially just shows a string of characters.

That would suggest either the label column is not set properly, or the Tasks Worked On column is not configured as an EnumList of base type Ref with a source table of Tasks.