Employee ID Lookup

notusmoon.cms · 2020-11-25T16:14:37.960Z

So I need some help with this. I want to make a Employee ID Lookup site where Employees ID are put ina database and then get pulled back with information to ensure that our Clients know our staff members are real. It would give an image of the staff, their name, etc. How would I be able do this?

ualdir · 2020-11-25T17:45:18.651Z

It’s very simple. Just add the fields that you need on User database and after create a page with elements that allow you show this data info. Last you have to create a input fild that allow you to make a search in your user database.

boston85719 · 2020-11-25T18:01:36.290Z

Create a data type called employee…on that data type add a data field called “Employee ID” make it a text type.

Then on a page where you want to search for the employees, you add an input element that allows a user to add an employee ID value into the input…make the input type text.

Then you need a repeating group that is of type employee with the datasource set to ‘do a search for employees’ and put a constraint onto it that is “employee ID = inputs value”…so this will return a list of employees that have that employee ID…

Or if you want to make sure it is only ever a single employee…create a group, make the type employee, and datasource is same as above, however, you would add to the dynamic expression at the end :first item so that you would only get the first employee in the database that has that employee ID.

Alternatively, if you want to allow users to search for employees by more than the employee ID alone, you can add other data fields to the employee data type such as first name, last name, department etc. and make them text types. Then when you do a search for employees you would use the constraint ‘any field = inputs value’

Then you would be able to search the employee data type and restrict the results based on any text field that has the value entered into the input element.

cmarchan · 2020-11-25T18:26:11.976Z

This is a super-basic user interface (up to you how you want to do it of course) made up of 4 bubble elements … just to illustrate:

image1201×756 38.6 KB

Then you add your database and flows …

image1228×491 50.7 KB

image1103×740 31.6 KB

notusmoon.cms · 2020-11-25T23:20:09.116Z

For the " constraint onto it that is “employee ID = inputs value”…" it does not show up input value as a option even if typed its just blank

cmarchan · 2020-11-25T23:39:14.851Z

Perhaps you can share a screenshot of the setup you have built.

If you set the input on the page it should as an option in the constraint of the search

notusmoon.cms · 2020-11-26T02:00:05.681Z

image632×545 28.6 KB

notusmoon.cms · 2020-11-26T02:01:11.390Z

it just doesnt show field value

cmarchan · 2020-11-26T03:35:38.515Z

Thanks.

If you placed an input or search input on your page then refer to it by its name and end the expression with “value”. So … e.g. if you named it “input search” then the expression should be “input search’s value”