Jump to content

DataTables Arrays integration

Recommended Posts

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. 
My thinking/observations:
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. 


Edited by dave17
Link to post
Share on other sites

Hi Dave,

Thanks for your interest in Carafe! As it happens, the two datatables bundles we have up there are two of the very first proofs of concept, and they aren't very configurable. In fact, we have a new consolidated datatables bundle in the works, and I'll dig that up today, and see if it's ready to publish officially. Even if it's not, I'll attach a pre-release version here for you to mess with.


  • Like 1
Link to post
Share on other sites

Hi again Dave,

I'm attaching a carafe bundle which you can import into Carafe Kitchen. Soon this will also be published on Carafe.FM, and we'll retire the two separate versions.


Just to wrap your head around the steps for deploying a bundle, maybe take a look at this video. It's talking about running a mapping bundle, but the process of creating the json in your loader script and passing it as the parameter to the deployed bundle script are the same. Just keep in mind that subsequent to this video we renamed the FileMaker utility "Carafe Kitchen" whereas the video shows it as just "Carafe"




Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Similar Content

    • By Russell Watson
      Hi Jeremiah,
      maybe this is a place we can pass Feedback to you about Carafe.FM?
      Improvement: UX confusing when search finds nothing
      Hi Jeremiah,
      I'm still goggling at Carafe ... and loving every minute of it! In general fantastic job on the UX of the whole app! Congrats!
      One thing is confusing ... when you search for something and nothing is found there is no feedback ... I then made the mistake of thinking the two little arrows to the right of the search box are for navigating the search term ... but clicking them doesn't work ... and then I realised, that they are for sorting ...
      Solution idea: Visual feedback
      It would be great if there was some kind of visual feedback to let you know that nothing has been found.
      Maybe a (very) quick and dirty fix could simply be a conditional format on the search box -> goes red when error 401 is active. (See image)
      P.S. Have you considered hosting the Carafe.FM FileMaker files on GitHub?
      You have your other Carafe-code on GitHub, why not the FileMaker files, too?
      OK, so they are binary files, but on GitHub we could leverage the Issue-tracking tools, and make use of pull requests, etc.?

  • Who Viewed the Topic

    8 members have viewed this topic:
    IdealData  comment  Wim Decorte  Bilaal Jarvis  mr_vodka  melmitts707  drschilling  Fitch 
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.