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.
Hello, I have a number field where I want the user to be able to enter things like:
42 (only item 42) 12+82 (only items 12 and 82) 1-5 (items 1 through 5) 31,33,35,37 (only items 31,33,35,37) So I am need of a way for filemaker to deal with the operators '+' '-' and ','
Do you have any advice on how I can separate out the item numbers?
Hi, in the same table i have 3 fields.
Name (this is the drop down of names)
I want to have so when a person selects their name in the drop down to complete this task that the current time stamp is filled in.
I cant seem to get it to do that but ideally i would like just one field with timestamp 15:30 21/02/2019
I also have about 50 tasks which people can do so hoping a more simple way instead of a fll script for each one.
Hope that made sense
Hi all, I need to go to different layouts depending on device and parameters and while the script functions fine for the desktop I can not get it to go to the correct layout in the iPhone. What am I doing wrong.
Sorry all, found my level of stupid and answered it myself.