NOTICE – I'm a bit of a noob when it comes to scripting. I do a lot of Google research, cutting, pasting, editing, research, etc. I haven't been able to find what I need for this dilemma although I think it should be fairly easy.
I need a specific cell cleared in sheet A (MaintenanceLogs) after submitting form data to sheet B (ClearMaintenanceFlag).
Sheet B contains the search data in column B that I want to search on column B of sheet A and clear the cell on the corresponding row on F in sheet A.
End user process
Users submit maintenance logs via a form (sheet A) and when they perform routine maintenance if they find something that requires follow-up, they check a box on the form that returns a "Yes "in column F. Column B of the maintenance logs contains a UniqueID generated when submitting its maintenance log.
When they correct the reported maintenance, they submit the unique identifier via the form that creates a log to indicate that the reported item has been corrected. We then want to remove the "flag" from the maintenance log.
As mentioned, I'm a bit of a novice. I can do an obvious search function to find the said identifier and return the data from the indicator column, but putting it all together in an automated script ……… I'm a bit lost.
I think I should have an onChange event ?? or on Submit? I just don't know the syntax to remove it. I have done a lot of reading but it is a lot for a noob to collect. Glad to pay to make it work.
At the end, we want the "flag" to disappear from the maintenance log. I use filters, etc. to create filtered lists that show the maintenance items still in progress, so when the indicator disappears, my list is updated.
Confidence that makes sense. If someone could point me in the right direction, it would be incredible.