Search Dataset in Drawer Form

App Building
1

I'm trying to build update a form to essentially look up information in a table based on an Employee Id entered at the top of the form.

The functionality would be that a user can input the employee id and this would result in populating adjacent elements on the form (employee name and work location).

I have an additional table on the canvas that uses this query to correctly pull the information I need:
SELECT * FROM rla__bsdt227_loa_employee WHERE employee_code = {{ requestsTable.selectedRow.employee_id }}

But I don't know how to implement a similar functionality that would pull the same information at the form level.

I thought of building something that would utilize a button trigger to look up this additional info based on employee Id.

drawer form
drawer form1150×620 52.9 KB

employee information table
employee information table1370×536 34.9 KB

2

Hey @adrquint,

I recently made this video that may be abe to help you, in your specific case it is the last way I explain. Let me know if you need more details