I am not sure if it possible to achieve what I am trying to do here, but basically:
I have created a form entry called Job Sheet. An operative will go to site add a job sheet entry - within that recording the location, time on site, time off, works completed, photo, customer name and signature etc.
However, currently this means prior to going to that job the operative must be told manually which client and address to go to, and what works need to be completed for that client and any other work instructions.
Is it possible to automate this, so the operative can open appsheet, see what jobs he/she needs to complete for the day (has been assigned). The information that he/she will need to see will have to include: Client Name, Address, Works to be carried out, further comments, access method. This information needs to be entered in by office staff. But ideally I would like the Job Sheet being completed by the operative as a separate form then the information being entered above by the office staff, if that is possible.