Input and save to different table

Hi everyone, i have master table employee and leave_trans table, i would like to create entry for employee who want to take the annual leave.
image

the employee name taken form employee master, the transaction would be saved to leave_trans table (name and date column).

thanks for helping.

A form that writes into the leave_trans table should be enough. When you configure the choice component, you will still be able to choose employee master table as the source of it

1 Like

Is there a reason you don’t configure it as a native form? It does look like you’re using a custom form there.

yes that is custom form, hopefully any suggestion in my case.

image

is’t possible to create custom button action unbound to employee table? the action button would execute to save data (name and date leave into trans_leave table).

Is it just an employee submitting for themselves or they can submit for others?

If it’s the first case, then you can just have a form container on the screen, insert a “Date Picker” component for “Date Leave”, and automatically collect the “Emp ID” as an “additional column” on the right-hand side.

1 Like

Thanks, I’ve now solved this issue

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.