I have created a data dictionary where I want to be the sole editer of the data (and all the users just view it), but when a user updates the main "shared" drive (that all the information the data dictionary is based on), I receive a trigger telling me that a file has been replaced and I need to update the data dictionary (an email is fine).
This is what I envision happening:
I create a mini database with a form that says:
"Please select the file you have recently updated:"
There will then be a textbox to browse and select a file
underneath that will be:
"Please select the file you wish to replace:"
There will then be a textbox to browse to select another file
I then want that after the user has selected the two files, they press a button that says "RUN" or something like that and the code automatically copies the first selected file and replaces the second one.
After this is complete, an email is sent to me telling me:
"This particular file has been updated, an update to the data dictionary is needed (and include the date that the copy happened at)"
Does anyone have any ideas? I think it seems easy but I'm not sure if I'm on the right track or not.
This is what I envision happening:
I create a mini database with a form that says:
"Please select the file you have recently updated:"
There will then be a textbox to browse and select a file
underneath that will be:
"Please select the file you wish to replace:"
There will then be a textbox to browse to select another file
I then want that after the user has selected the two files, they press a button that says "RUN" or something like that and the code automatically copies the first selected file and replaces the second one.
After this is complete, an email is sent to me telling me:
"This particular file has been updated, an update to the data dictionary is needed (and include the date that the copy happened at)"
Does anyone have any ideas? I think it seems easy but I'm not sure if I'm on the right track or not.
