I’m having a problem with using dblookup to find and return birth dates from a view on my database. Here’s the situation:
I exported a csv file of names and birth dates from a person management system and imported the csv into my workflow app as a view. The csv contains last name, first name, and birth date. In the view, the first column is a calculated column containing (Lname + ", " + Fname). The second column is just the birth date.
On the form, Field 1 is a combobox which references column 1 (full name) as it’s choices. A hidden field, Field1_selection, returns the selection made in the first field.
Field 2 is a DOB field that is calculated depending on the name selected in Field 1. This is how I programmed Field 2:
@if(Field 1 = “”;“”;@dblookup(“”;“Server”:“Folder”;“Name View”;“Field1_selection”;2;“”)
After selecting a name, the Field 2 returns:
ERROR: Server Error: Entry not found in index
Help?