Forum Discussion

AlexCouts1's avatar
AlexCouts1
Qrew Trainee
2 years ago

Employee Records not appearing in drop down selection menu

We have an employee database where employees are able to generate time-off requests to be approved by their manager and correspond with accounting information for PTO purposes. Requests are made using a form from a table that holds records of PTO requests, each new request adds a record to that table. 

Currently, when a user goes to edit the form, the drop down selection list signifies that it has found records (20 records, the amount of employee records) but the select options in the menu are blank? they are select-able and employee information does populate the subsequent fields once an option has been selected but I cannot get the records to actually appear in the drop down list. Typing anything in the box to filter, filters out all records. 

Before Selection:

 

After Selection (populates information):

At the field level for the table that the time-off table is referencing (employee name is a look up from the employee records table) I have selected the options that would allow this information to appear in drop down selection menus, but this doesn't seem to drive any change in the form: 
Any recommendations on where to go from here? Thank you in advance! 



------------------------------
Alex Couts
------------------------------
  • The value setting on that relationship is blank.  Check the lookup field options and then the value from your screen shot.    It's blank, but it should point at the Employee name field. 



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • AlexCouts1's avatar
      AlexCouts1
      Qrew Trainee

      While you were definitely correct about the field value being blank in the relationship, I went ahead and changed this: 
      but am still not seeing the options appear in the drop down?



      ------------------------------
      Alex Couts
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend

        Try going to the advanced properties for the source table and set the "Record Picker" first field (of the three offered) to be the name field.



        ------------------------------
        Mark Shnier (Your Quickbase Coach)
        mark.shnier@gmail.com
        ------------------------------