Hi All,
I am after some advice please.
I have currently got a sheet and web form set up that my engineers use to check out instruments when they take them to site and then check back in when they return the instrument or the instrument changes hands however I am running into some trouble.
At the moment every time an instrument is checked out a new line is created within the sheet. This causes a disconnect between the 'Date Out' Columna and the 'Date In' column which means instruments are being missed off the list.
Now, having investigated and read up on the subject, there isnt currently a way to get a web form to update an existing line within a sheet (unless I have missed something?) but does anyone have any advice of an alternative way of achieving this?
Any help or advice will be greatly appreciated.
Thanks,
Graham