Parent Child picklist

[giri-f6a5]

How to make parent child dropdown/picklists in Honeycode.

[DanielTet]

hi @giri-f6a5, welcome to Honeycode and this forum, glad you are exploring building. If the examples below don't match your needs let us know your specific use case, or give some screenshots, and we can recommend something that may work better. In general the child picklist will have to use a FILTER to show only the relevant rows to show. If you put two picklists, A and B on a screen:

• The first one (A) will be a simple rowlink to a table
• The second one (B) will be a rowlink to a filter
• The filter will look something like this (assuming that ColumnName and A are linking to the same table:
  =FILTER(TableName,"TableName[ColumnName]=%",$[A])

Here is the article on Filter function:

Filter( )

FILTER() Description FILTER( ) filters a table or filter and returns a reference to rows matching the criteria when set as a source for a list. Multiple conditions can be combined using AND or OR. Syntax =FILTER(table, "condition", [condition_parameters, ...]) Required Table/filter: A table or filter that returns a list of rows. Optional Condition : Specify one or more Boolean formulas as a condition. Conditions can contain any supported functions Condition is expressed as a quoted st…

Here are some more examples from the community; they will ask for more complicated and deeply nested picklists but you should be able to get some good ideas:

How to create a sub-picklist?

Hi, I want to create two picklists, where the chosen option in picklist1 determines the available options in picklist2. I created a table1 which contains one column with the main categories. I created a table2 which contains column1 with the subcategories and column2 with the main categories. I wrote the filter for picklist2 as follows : =FILTER(Table2,"Table2[Column2]=$[Picklist1]") , which gives me an empty picklist2. If I replace the reference to picklist1 and just enter the chosen main ca…

Formula to remove options already used

I have multiple data cells using rowlinks from a table on the same screen. How do I make options disappear in the dropdown list once they are used in another data cell?

Hope this helps,
DT

[Benj-566a]

I am trying to return a filter of d_Projects where $SYS_USER is assigned to a task that is assigned to a project.

d_Projects has: Name, TeamLead ($SYS_USER), and other columns that don't really matter right now.
d_Task has: Name, TeamMember ($SYS_USER), Project and other columns that don't really matter right now.

I have played with a few formulas just to try to return projects with task assigned to sysuser, but I just can't seem to get it to work.

'=FILTER(d_Projects,"d_Projects[Name]=d_Task[Project] AND
d_Task[TeamMember]=$[SYS_USER]")'

This seems to have gotten me the furthest, but it seems to only return one project and some logic that I am missing is determining the project.

I feel like I need a nested filter or something but I just can't figure out the right syntax for a nested filter.
Something like
'=Filter(d_Projects",d_Projects[Name] = [Project]", filterResult = Filter(d_Task,"d_Task[TeamMember] = $SYSUSER")

[aj]

Hello @Benj-566a, I believe you could do the following...

1. Create a column in the d_Projects table, for example, Related_Tasks. For column format, use the formula: =FILTER(d_Task,"d_Task[Project]=THISROW()")

2. In Builder, for your List source, use the following formula: =FILTER(d_Projects,"d_Projects[Related_Tasks][TeamMember]=%",$[SYS_USER])

Hope this helps!