Leaderboard

SCCopy does make an entirely new copy of the file at the specified location. I ran a test by uploading a file to <superContainerURL>/Files/test and uploaded a file at <superContainerURL>/Files/test2 . I then used SCCopy and copied the file at "test" to the "test2" location. I then dragged and dropped a completely different file onto the "test" location, went back and refreshed the "test2" location and the file at "test2" did not change and was the same file as it was after using SCCopy. I suspect you may have some kind of logic that runs when you "overwrite" the file that is also overwriting the other locations. SuperContainer is "dumb". It doesn't know anything about the relationships in your FileMaker file so to SuperContainer these images are independent. Assuming you are using the function SCDownload to download files, the function will download the file from the path this it is provided. If you are getting a "file not found" error then I suspect that there is a flaw in the process that provides the function with the file path to download. Either a null value is being provided or the path being provided is malformed. I recommend debugging whatever logic runs when you check the checkbox and making sure that what is being provided to the function is valid. Please let me know if you have any questions!

It's true, it doesn't make a lot of sense given that once in Manage Security, you could simply change the password of a full access account, or create a new full access account, and then authenticate with that when closing the dialog. All the more reason to not use EA for full access!

Well, it's a demo. In the real implementation, you can select the type for the user beforehand - e.g.by a script triggered on OnLayoutEnter - and hide this from the user.

You were almost there: make the calculation = GetSummary ( summary of id ; Type) / summary of id and format the field to display as Percent.

Where exactly do you see globals in this situation? The categories of a contact are property of contact, so this certainly cannot be a global field. And if you only ever want to see clients from Invoices, why would you use a global for this? Now, you could use a global field to select the category for the value list. But then you would have to populate it with "Client" before trying to use the value list from Invoices. OTOH, you would only need one value list, not three - see the attached demo. GlobalCategoryVL.fmp12

You can use a text object containing only a space as the background for the portal row.

I tend to use repeating calculation fields for this type of display. A repeating field can be summarized individually for each repetition, using a single summary field.

See also: https://support.filemaker.com/s/article/Word-separators-in-FileMaker-Pro-1503692915258?language=en_US

Here's a very useful community thread.https://community.filemaker.com/docs/DOC-8174 See Josh's comment: It is important to set the $$Path in a script that does NOT have any use of the $$Path.

To clarify a couple of points: - When you're on a form view with no fields, no data is fetched. - If ONE field is present, then ALL data from THAT RECORD is fetched. I.e. ALL FIELDS from that record. The other big difference in form view is that you're only viewing ONE record. In table or list view you might be looking at many records. Check out server under the hood for more: https://youtu.be/VCrNP4VZiM4