Share
ReportI have a form that doubles as a new employee/new cert/qual upload form.
I have the following in the OnChange property of the employee 'Unique ID' field of the form.
Set(varCQRecord,First(Filter(SFPrgrmMmbrsCollection,Title=DataCardValue7.Text)));
If the employee is already in the system the form will auto-populate any data already in the system. Anything missing specific to a new cert or qual the User manually fills in.
I'd like the 'Unique ID' condition to also include If OnChange the employee's 'Unique ID' is not in the SFPrgrmMmbrsCollection (meaning not in the system at all), all fields defaulting to auto-populate would become required fields, requiring data before the form is complete and the data can be patched to the list.
Or, would it be better to just create a copy of this screen and make it exclusively a 'New Employee' screen, and make this one a 'New Certs or Quals' only upload screen?
All responses (
Answers (
429
