Hi,
I am looking for some assistance with an application I am working on in an appsheet.
Basically, I am working on a dispatch/tracking application for a logistics company and the main area of focus right now is tracking the duration of each task e.g. loading a pallet or setting up a pallet.
One task can be done by a different person each day and so part of the process is capturing who is doing the specific task. On the appsheet app you select the task followed by the employee name of who is doing the task which is done from the selection of the employee name from a drop-down list and then a start button which initiates the process and complete button which indicates the completion of the task.
However, I am having an issue with the employee selection from the dropdown list, when the said employee name is selected on its own form (Drop Down List) it is not populating the respective Employee Name cell in the worksheet and so does not show on the details view of the appsheet application, the employee name only appears when there is data entered into it on the details view of the appsheet application. If I go into the worksheet to the specific table/sheet and enter an Employee name into an existing row in the Employee Column and then sync the application the Employee name shows on the details view.
This is an everyday process which basically means each row is updated daily by duration and employee name and all other columns remain the same.
So, in a nutshell please can I get assistance with capturing the Employee name from the drop-down list into the Employee Name Column or any suggestions in capturing the name using a textbox so that it populates the Column.
NB If I validate the start button to only allow the starting time to be captured only if the employee’s name has been captured successfully it never works because it does not recognize when an employee name has been selected on the Employee Name form (Drop Down List) due to it not populating the Employee Name Column.
