Does it matter if the back end linked spreadsheet is not in the location indicated in Info>Properties>Default app folder?
I have an app that indicates a different folder in the Info>Properties page than where the spreadsheet is actually saved.
I have found that if I link a file (video, image) using a relative path, I cannot use the folder indicated as the default.
Rather, I have to use the folder where the spreadsheet is actual stored.
Can I manual update the default folder in Info?
And MOST IMPORTANTLY:
If I move the spreadsheet to the default folder, is there a way to re-link the spreadsheet without loosing all of my column settings?