BruceR

I did not attend Devcon this year. But I see that Kevin Frank posted the following comment recently on a different list. And actually - even elsewhere in this forum. But I thought it might be good to add his comment within this thread. Anyway, quoting him: https://filemakerhacks.com/2017/07/27/json-virtual-list/

Your question is about only-related-values value lists. Yet you did not select this feature. If you do; it works.

Created a clone, cleared the container field, imported data into the clone. 762kb. Timesheets_Tester.fmp12.zip A "delete everything" relationship when you delete any record is NOT a good idea. The file has serious design problems, you need a proper table structure. The field list hints at what you're trying to do but it's a mess. Find a qualified developer. (Not volunteering)

One issue with file size is the global container field, 20MB, a FileMaker file MQOS Color Horse 2.fmp12

It isn't clear which part of the process you are having trouble with. You did successfully upload them; but they won't open using open remote? You can't get them uploaded onto the server? You are using the FileMaker Server credential to upload; not the solution username/password? You upload from FileMaker Pro; not server admin.

Thought you were saying you would start the thread! So - we'll see.

You're welcome. Short answer re JSON; would adapt well. Have not pursued it yet. Yes, probably better to start a different thread, some examples might get submitted.

Sometimes it's better to just recognize and accept current limitations, proceed to do a few minutes work, and get a clear, scripted solution. Which provides the result you need and provides a script that you can adapt, monitor in debugger, print, review, etc. See attached mod to your file. Sort_by_field_object_name_MODBFR.fmp12

Not a bug. You're a novice. You exit script in the middle of your GTRR action. Don't.

"I can't think of any other way to do it." Wow. Well; we can; and you been repeatedly given correct instructions. Listen to what Laretta and Comment have told you.

Though hosted, you can use the backup features of the server admin control panel to generate a clone; and download that.

The 10 takes into account the entire length of the start phrase. But here's a file with a few script mods to consider, including a global field to determine which occurrence you are searching for. TestEmailParse_MODBFR.fmp12.zip

Not necessarily. You can leave the field unformatted; and use simple templates and substitutions to apply different tab sets. You can even apply different tab sets to each line. See attached rudimentary example. ColumnFormats.fmp12

I would think that terms would be failed or passed. Seems a very unusual and inappropriate use of "win".

Impossible. You have not unchecked them all.Your screenshot, for instance, does not show the top of the script list.