|
|
|
|
|
|
|
|
|
|
|
|
|
|
Global Web profile documents (continued)
FIGURE A
 
The Calendar Profile form stores day and month names in different languages. Roll over picture for a larger image.
For proper display in the popup calendar, I limited the size of the day names to two characters, and the month names to three characters.
The last field we need to add is the "Lang1_digest" field. This computed field creates a text list of the values in all the other Lang1 fields so that we only need to use a single @Dblookup command to get all the data we require for a specific language. The formula for the Lang1_digest field should be:
Lang1_SU : Lang1_MO : Lang1_TU : Lang1_WE : Lang1_TH : Lang1_FR : Lang1_SA : Lang1_Jan : Lang1_Feb : Lang1_Mar : Lang1_Apr : Lang1_May : Lang1_Jun : Lang1_Jul : Lang1_Aug : Lang1_Sep : Lang1_Oct : Lang1_Nov : Lang1_Dec
|
To create fields for other languages, use the same field models, just increment the number in the field name so that Lang1_SU becomes Lang2_SU for your second language, and so on. Save and close the CalPro form.
Now we need to create the cal_profile view we referenced in the SaveOptions field of the CalPro form. Create a new view and call it "cal_profile". The view selection formula should be: SELECT form="CalPro". See Figure B for an example.
FIGURE B
 
The Calendar Profile view ensures only one document ever gets created with the CalPro form. Roll over picture for a larger image.
The first column in the view should be sorted ascending and it should have the simple function value "# in View". The second column will provide a list of name value pairs for each of the supported languages. The format for this list is the same as for drop down field lists: Name | Value. The formula for this column is:
(Lang1_name +" | Lang1"):(Lang2_Name + " | Lang2")
|
Add as many elements to the list as you have languages to support.
Our last bit of work on the calendar profile view is to create a button that will let us create a new profile document if one doesn't exist, or edit the existing one. Create an action and give it a formula value of:
test:= @If(@IsError(@DbLookup("";"";"cal_profile";"1";"docid")) ;"";
@DbLookup("";"";"cal_profile";"1";"docid"));
@If(test="";@Command([Compose];"";"CalPro");
@URLOpen("/"+@WebDbName+";/"+@ViewTitle+";/"+test+"?EditDocument"))
|
This formula is similar to the one we used in the SaveOptions field. First, we do a test of a database lookup for the calendar profile document. If it exists, we fill the test variable with its unique id. If not, then the test becomes an empty string.
The second line opens a new CalPro document if the test is empty (no existing document). If the unique id of an existing calendar profile was found, it forces the browser to open that document in edit mode.
Save the view and select the "Preview in Web Browser" option from the Design menu in Domino Designer. Click on the action button you just created and you should get a new blank form. Fill it out and save it. Now, whenever you click on the action button it should open your existing document in edit mode.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-- Advertisement --
Sophisticated Meets Simple For Document Management
Share. Control. Manage.
Documents, emails, and content in the context of how work is done.
Native to Lotus Domino. The User Experience unseen for Lotus Domino.
Do more with less. Really.
See the possibilities Docova unleashes for Lotus Domino. |
-- Advertisement --
Integrate your Notes Applications with Microsoft Office and Symphony
Integra for Notes Integrates Microsoft Office and/or IBM Lotus Symphony
Requires NO change to the design of the appliation or Installations of DLL's and EXE's
- Integra is a ready to use solution, enhance static reports with Excel data analysis, pivot tables, macros
- User friendly aproach, using a point and click access to features
- Reports from any Lotus Notes databases
- Runs reports through a Notes client, web browser and scheduled basis
- Allows use of LotusScript for advanced data manipulation
- Enables self service reporting capabilities to end-users
Learn more at www.integra4notes.com. |
|
|
|
|
|
|
|
|
|
|
