Dropdown menu for different criteria

Hi,

I have two clients and I do not want them to see the whole drop down list, just want to show some based on the client. How should I do.

Client : A, B

Drop down menu for A : A1, A2, A3...

Drop down menu for B : B1, B2, B3..

I want to use the same column for the drop down menu for creating the report. Any ideas for this?

Find more posts tagged with

Accepted answers

All comments

Andrée Starå

Hi @Api

I hope you're well and safe!

I'd recommend adding two so-called helper columns, one for each client, and then having a formula collecting the results from both in your original Dropdown Column so you can use it in the Report.

Make sense?

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Api

Thank you for comments, but i'm still blank on this. Do you have some example of formula for the specific question

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.