Hi, i have an inspections table with some info and an Inspection Photos table which the user can use to add images that are linked to the inspection table. Those images are stored in the folder with the default naming convention (Inspection Photos_Images) and each Image has a folder path of โInspection Photos_Images/[Inspection Location]/[Inspection Date]/โ.
My question is, is there any way I could create a hyperlink to each Inspectionโs Photos folder on Google Drive or is the data encrypted etc.?
Optional question: The Inspection Date is translated into three subfolders in the form of โ08/26/2020โ instead of just one folder. Any way around this?
You could reformat the date with a TEXT() expression something like TEXT([Inspection Date],โMMDDYYYYโ) which will result in only one subfolder instead of three with subfolder name as 08262020 for example.
User | Count |
---|---|
41 | |
29 | |
22 | |
20 | |
15 |