Just wanting some advice on the best way to approach this. Currently I have a Microsoft form which updates a persistent excel spreadsheet. This feeds into a daily “duty sheet” which has a list of all staff that are on duty today utilising one drive.

Member of staff fills in the form with their working location and if they require an extension number. This is sent to the persistent form results sheet and a data link to the duty sheet updates their working location, generates an extension number and puts this next to their name

Issue being, a supervisor needs to have the form results sheet and the duty open (in app) for the data to flow and constantly update. However, internet speeds, user error etc can cause delays for staff retrieving their extension number so I’m trying to think of a way for a member of staff to fill in a form, this is sent to the spreadsheet and the staff member is presented their extension number instead of having to wait for the online version of the spreadsheet to update.

I’ve looked into JavaScript but that doesn’t seem it will work. I’ve looked into php but seems I would need to host this on to a server for it work.

Any suggestions on how you would approach this? I considered vba, I do have a system whereby you submit the form, this is sent on an email and the duty sheet downloads the emails and updates them emailing staff back their extension number, but this requires someone to physically press the download button unless I run a time event to download emails every couple minutes?