By Tony Diaz
The Genre data is already arranged like this:
Genre::ID (Unique Key)
The Platform data is 'simple'. ID and Name. But each item could be multiple platforms. (Example #1 vs. Example #2)
An item can have multiple Genre Categories related to it, and those usually have a single choice from within their Category, but might have multiples.
It's supporting the possible multiples that I'm trying to work out. At this point there's 15 possible Genre Categories that each Item could have a selection from. Most have 4-6 of them.
Example 1: Items::Table on the left, Genre::Table on the right, with some Genre Categories (Genre, Perspective, Pacing, Gameplay, Interface, Setting) and their sub-options.
This one has just one sub-option per category.
Example 2: The Gameplay Genre Category has two sub-options related to it.
Example Genre Table content:
Just cracking the surface on One to One and One to Many relationships, I don't think this scenario is quite covered this way.
Would each of those Genre Categories be portals showing only their related category ID?
I presume that I would add fields to the Items::Table so I can pull related records:
But those only support one relationship.
Would I make value lists from those Genre Categories and Platforms and set them as tick box fields?
By Tony Diaz
How do I set a field with a value list item from a script, from a set of tick box values? .. or remove a value list item, but leave whatever else is there alone?
Looks like GetValue with the name of the value list and the position # of the value, but I'm sure that also means that if I change that value list, I need to change any scripts that reference them by position # too..
Something like detecting if a string is already there, and if not add it, surrounded by C/Rs, unless it's the first item entry?
For the first time a field is set, I presume I could just Set Field (field ; "Value List Item"), and if there's only one entry/line in it, just clear it. But if there's already a value there, I just want to select an additional one.
I have two iPads connected to FM server. For some reason one ipad (5th Gen running 13.5) will not complete the navigation scripts and shows error messages (no records match this find criteria), however the 7th Gen running on 13.1.1 works fine..... Issue has only begun after purchasing the second, newer iPad. I cannot for the life of me work out what is wrong, or how to troubleshoot and would love some guidance please!! Here is a screengrab of one of the scripts and related layout:
fm go script issue.tiff Orders iPad layout.tiff
I have a Preference table with status options. The user can create a new status and through a script can assign a color (see attachment). The calculation is the following:
Allow user abort [off]
Set error capture [on]
Set variable [$start ; value: Get ( ActiveSelectionStart )]
Set variable [$end ; value: Get ( ActiveSelectionStart ) + Get ( ActiveSelectionSize ) -1 ]
Insert Calculated Result [ TextColor ( Middle ( Get ( ActiveFieldContents ) ; Get ( ActiveSelectionStart ) ; Get ( ActiveSelectionSize) ) ; Get ( ScriptParameter ) ) ]
Set Selection [ StartPosition : $start ; End Position : Send$ ]
The ScriptParameter has the color values in RGB: RGB ( 237; 41; 190).
The Status field is pulled into a Value List for the Product table. Is it possible, once the status is used in the Product table , to convert the text color into a conditional formatting? Is my approach wrong? I am trying to give the user some flexibility.
Thank you for guiding me.
By Agnes Riley
I'm getting "The file "" could not be opened. Either the host is unavailable, or the file is not available on that host."
This happens when a script runs. Not a new server, no new files. The file is actually open in the background. The file reference is just "file:".
I restarted the server. Didn't fix it.
It's apparently intermittent. I copied all the script steps to a new script, then it worked 3 times, but couldn't find the file for the 4th time.