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?
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.
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.
1 Like
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:
Then you add your database and flows …
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
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
it just doesnt show field value
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”