I downloaded the DataTables Arrays bundle. I have the script installed in the solution wherein I want to utilize it. But I'm sort of lost trying to get it to read data from my solution instead of the baked-in default data provided with the bundle.
It looks as if the $parameter isn't getting set with my data.
It looks like I need to provide my data in the form of a JSON array, but I don't know how to do that.
It looks like the built-in $contactTable variable need to contain a table in my solution instead of the hard-coded array that's in the script's ELSE statement on line 25.
I created a DataLoader script in which I tried to correct my observations above, but I get no results in the webViewer on my layout. My assumption was, that since contactTable is being set with $contactTable as written, that I should replace $contactTable with a table in my solution. That didn't work.
Can anyone help guide me to getting this thing to read my Table's data (about 86K records of time/labor entries)? Has anyone here tried implementing this? Carafe bills itself as "easy" so the fact that I've now spent a few hours with it to no avail makes me feel less-than-great about myself.
By Joost Miltenburg
using FM18v3 I defined an import, update using key with option :add remaining.
Odd enough, when running the import for the first time, the key field remains empty. (Unexpected)
As a result the second time I run the script I get new records, but now the keyfieldfield is filled. (Expected) The third time the import also runs as expected ( no new records ).
I fixed this by defining this script in FM18 using an if. Eventually, I launched FM17 and re-did the script. Now it works like it should.
Anyone else can replicate this?
Most of my medium to heavy scripts are now performed on server. To give the users some feedback while they wait, I wanted a method that was simple and subtle. In this example I ;
added a popover button with '+' icon set the feedback message in the popover title bar formatted, sized and positioned the popover added a OnObjectEnter script tigger to the popover in the script I add a PSoS step with Wait for completion set to 'On' last step of script is Close Popover
I have stumbled upon a strange bug in one of my Databases concerning a value list.
We have a table containing part numbers, which is related to a table containing "revisions" for the part numbers, which is related to a table of inspections for the "revisions".
On a layout of the Inspections table, I have a value list. This value list selects the UUID of the revision, but displays the Part Number for the user.
This has worked perfectly for several months. However, this morning one of my users discovered that he was unable to located "0000194" from this list. At first I thought maybe the UUID's somewhere along the line had become disconnected from their respective foreign keys on related tables. This was not the case. I then tried deleting and remaking the value list. This did not solve my problem. Then I figured if I deleted and rebuilt everything related to 0000194 that would fix it. This was not the case either. As a last ditch effort I restarted our FileMaker server, to no such luck.
So then I began playing around with various aspects of 0000194. First I changed the company name, but it still didn't show up on the value list. Then I changed the part number to "TESTPART", and it showed up perfectly. So I tried "0194" and that showed up. Same for "00194" and "000194", but as soon as I add a fourth zero making it 0000194, it disappears from my value list. I'm 95% sure that this part number used to show up on the value list just fine, as we've already done inspections using this part number. So I'm thinking this bug has something to do with the leading zeros. I'm unsure of how to debug this or if there's any workarounds for this issue.
Let me know if I need to supply any more information.
Thank you in advance for any help you all can offer!
[SOLUTION] At some point one of our scripts was run by a user without full permissions. The script added part number "0000194" to another customer, which I never noticed. Since Value Lists are indexed, it was not showing "0000194" because it was not a unique value. Deleting the second occurrence of "0000194" cleared my problem up.
By Jonathan Ackerman
I am developing an app where users may login with Android or IOS via Webdirect.
On IOS (safari) via Webdirect-- everything is fine.
With Android(chrome)-- anytime the script refreshes the screen or switches panels-- all uncommitted data is lost.
any ideas or workarounds?--
my script checks validation and i really need to refresh to trigger conditional formatting
also hoping to have a multi-panel entry so the user does not have to scroll to the bottom (layout has about 100 fields)
Who Viewed the Topic