I have a view with 2 columns, Workstation No. and Check
I want to use a formula in “Check” to display the word “in used” if the “Workstation No.” in column 1 corresponds to a another view in another database which has the same list of “Workstation No.” but only those that are in use. While those that do not match will just be left empty.
If possible, how do i write the formula??
Subject: View formula question.
You can use @DbLookup to get to desired document. When you have a view with 2 columns in the targte db: one for the key and the other for the value you are looking for, you can use this value to show the correct text.
Subject: RE: View formula question.
hi, can u elaborate… or tell me the formula cuz i’m new at DD.
Subject: RE: View formula question.
When you are not certain about a function you might have a look in the Designer’s Help db. This text comes from that db. It shows how to use @DbLookup and handle the result.
This example looks up a person name in the People view of the local Address Book (names.nsf) and gets the office phone number in the document containing that name.
inputName := @Prompt([OkCancelEdit]; “User name”; “Enter user name as FIRST LAST”; “”);
adjName := @Right(inputName; " ") + " , " + @Left(inputName; " ");
phoneNumber := @DbLookup(“Notes” : “NoCache”; “” : “NAMES”; “People”; adjName; “OfficePhoneNumber”);
@Prompt([Ok]; “Office phone number”; inputName + "'s office phone is " + phoneNumber)