i am using Zoho Creator to mark the attendance for my staff:

Form: Attendance_Form - has the Field:Employee_Name (its is a lookup field from Form: Employee_List Field: Staff_Name)

i want that when i select the name of staff from Field: Employee_Name, it should Concatenate the name of the employee with the Field: Date_Field (with is also in the Form: Attendance_Form)

Example: if i am marking the attendance of "09-11-2018" (DDMMYYYY) for Staff "Mark Rogers" then the output of the concatenate function should be "Mark Rogers09112018"

After Concatenation is successfully achieved, i want the script to also check if the Attendee of Staff "Mark Rogers" has already been marked and give me a warning Message "Attendance Already Marked"