Solved

The View shows the Checkbox's synonym

Posted on 2006-06-29
7
296 Views
Last Modified: 2013-12-18
I've a checkbox with many choices e.g. Hardware | A4

The Form shows Hardware that's OK but the View shows A4
How can I get the View show Hardware instead of A4?
0
Comment
Question by:verto33
  • 2
  • 2
  • 2
  • +1
7 Comments
 
LVL 46

Accepted Solution

by:
Sjef Bosman earned 25 total points
Comment Utility
Use a translation formula:

    @Replace(CheckBoxField; "A4":"A5":"A6":....; "Hardware":"Software":"Tupperware":...)
0
 
LVL 13

Assisted Solution

by:CRAK
CRAK earned 20 total points
Comment Utility
I often throw in 3 fields to (A) allow dynamic changes to the lists of choises and (B) speed up views by less computations.

1st usually has a suffix "_choises" (e.g. "myField_choises", text, multi value, comp. for display, hidden)
Formula could be anything like "choise1|A":"choise2|B", a @DbLookup etc.

2nd ("myField", editable, radio, checkbox, combo or such) retrieves its values from that field (_choises".
This would be your current field.

I usually give the 3rd a prefix "_selected" (e.g. "myField_selected", computed, multi value, hidden).
Formula:
input_lst := myField_choises;
select_lst := myField;
input_scrambled_selection := @ReplaceSubstring(input_lst; select_lst; "");
input_delete_unscrambled := @Replace(input_lst; input_scrambled_selection; "");
@Trim(input_delete_unscrambled)

(input_lst and select_lst refer to the 2 fieldsnames that were used ealier. Change those if applicable; the rest of the formula is reusable)

This will deliver e.g "choise1|A" (or in the case you provided: "Hardware|A4").

You perform a @Left(....; "|") on the result.
The last line of the 3rd field's formula would then read:
@Left(@Trim(input_delete_unscrambled); "|")

Or, if you dont mind the computation in a view's column:
@Left(myField_selected; "|")
0
 

Author Comment

by:verto33
Comment Utility
I guess I should ad the @Replace formula to the Input Translation.
I did it but it is as before, in the view (in the column) I see still A4, A5 etc.

I will test the command and if nok I remove the synonym from the checkbox.
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 18

Assisted Solution

by:marilyng
marilyng earned 20 total points
Comment Utility
Verto33,

where did you put the translation formula?  on the form or in the view?  I think you put it in the form?  Try putting it in the column formula on the view.

As both sjef and CRAK indicate, when you have a formula with an alias, Hardware|A4, and you select "Hardware"  the "Hardware" shows up on the form, but the actual value is "A4" which shows up in the view.

So you either have to use the translation formula in the VIEW as sjef suggests, or as CRAK suggests, add another field that "translates" the value so you can use THAT field in the view.
0
 
LVL 46

Expert Comment

by:Sjef Bosman
Comment Utility
This is all because the view doesn't know anything of the form. As Marilyn says, the alias is stored in the document, but the selected value is only known in the form, and nowhere else. That means that you have to do some translation in the view. But, whenever you change the form and add new values and aliases, you'd have to change the view as well!
0
 

Author Comment

by:verto33
Comment Utility
Yes, I put it on the Form.
When I saw that I've to use the Translation formula I immediately thought on the Input Translation of the field because the column has no other part as Column Value.

It works now, thanks.

0
 
LVL 13

Expert Comment

by:CRAK
Comment Utility
Sorry I wasn't there for you today. Glad to hear you've got it working with the help of my friends.
Thanks for the point & help, all!
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

I thought it will be a good idea to make a post as it will help in case someone else faces these issues. I trust this gives an idea how each entry in Notes.ini can mean a lot for the Domino Server to be functioning properly. This article discusses t…
Lack of Storage capacity is a common problem that exists in every field of life. Here we are taking the case of Lotus Notes Emails, as we all know that we are totally depend on e-communication i.e. Emails. This article is fully dedicated to resolvin…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now