This topic is 2066 days old. Please don't post here. Open a new topic instead.
there is a price list in Excel with images embedded. Do you have an idea how to import those records into DB with corresponding images preserved?
Note that I've attached only two records, there are 600 of them. Any manual manipulations with the images is not an option.
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 am trying to import data from a MySQL database and need to somehow also import fieldnames to be the fieldname in FMP. Is there anyway to do that? I have a CSV of the fieldnames and I also have a MySQL dump of fieldnames and associated data.
Thanks for any help.
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.
Who Viewed the Topic24 members have viewed this topic:ChristophL Ismail AlAbdulmohsen Nuri Baba bcooney Steve Martino OlgerDiekstra comment Cable Dr.Gopala krishnam raju AMBATI Fitch Jesus Humberto Alonso Gamez Al Quimby Matt.C rwoods Josh Ormond Matthew R White 1FilemakerMan arni mr_vodka Backe11 doughemi Edwin1965 Aussie John wattmhite