• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 192
  • Last Modified:

How to show values in second column which based on first column in the view?

Hi all,

Need help urgently to resolve this problem.
I have a form (called "frmAdvInfo"), which has 10 fields (called "SkillCseNm1", "SkillCseNm2", etc) for users to key in "Skill-based" Course Name, and another 10 fields(called "KnwCseNm1", "KnwCseNm2", etc) for users to key in "Knowledge-based" Course Name.

So in a view, I need to show the Category of the Course Name (whether it's "Skill-based" or "Knowledge-based") in the 1st column. In the 2nd column of the view I need to show the Course Name, ie. if the Course category is "Skill-based", I need to show the values of "SkillCseNm1", "SkillCseNm2" etc fields. If it's "Knowledge-based" course, then I need to show the values of "KnwCseNm1", "KnwCseNm2" etc fields.

I have managed to show the first column values (ie, the category of the courses - Skill-based or Knowledge-based).
Here is my formula of 1st column:
tmpSkill := @If(@Trim(SkillCseNm1)!="" | @Trim(SkillCseNm2)!="" |@Trim(SkillCseNm3)!="" | @Trim(SkillCseNm4)!="" | @Trim(SkillCseNm5)!="" | @Trim(SkillCseNm6)!="" | @Trim(SkillCseNm7)!="" | @Trim(SkillCseNm8)!="" | @Trim(SkillCseNm9)!="" | @Trim(SkillCseNm10)!=""; "Skill-based"; "");
tmpKnw := @If(@Trim(KnwCseNm1)!="" | @Trim(KnwCseNm2)!="" | @Trim(KnwCseNm3)!="" | @Trim(KnwCseNm4)!="" | @Trim(KnwCseNm5)!="" | @Trim(KnwCseNm6)!="" | @Trim(KnwCseNm7)!="" | @Trim(KnwCseNm8)!="" | @Trim(KnwCseNm9)!="" | @Trim(KnwCseNm10)!=""; "Knowledge-based"; "");

Does anyone know how to resolve this?
Thanks very much in advance.

1 Solution
Can a document have both skill and knowledge based, or should it only have one type.
if it can only have one type, this is how I would do it.

have a radio button on the top of the form, where user chooses skill or knowledge.  Now, you only need ten fields CseNm1...CseNm10,  The first view column will just be the radio button field.

If you need to allow both, then what you should do is have a single column that categorizes on two parts. Here's your formula:

SkillNames := @Trim(SkillCseNm1 : ... : SkillCseNm10);
KnowNames := @Trim(KnwCseNm1 : ... : KnwCseNm10);
Skills := @If(SkillNames = ""; ""; "Skill-based\\" + SkillNames);
Knows := @If(KnowNames = ""; ""; "Knowledge-based\\" + KnowNames);
@Trim(Skills : Knows);

This column should be categorized.  Even though it is a single column, it will be treated as two categorized columns, separated by the \\
kspueaAuthor Commented:
Yes, the document can have both types of courses.
Bingo, qwaletee! Your method is working wonderful!!!  :-)

Thanks very much!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now