Jump to content


  • Content Count

  • Joined

  • Last visited

  1. Correct. My goal would be to build a pie chart (or other viz) that shows the percentage of the total attributed to each individual name. Yeah I mostly work in d3. It's getting the data to d3 that can be tricky :-)
  2. I'm trying to pass parameters through Caspio between a submission form and a series of datapages (as seen in this training video: However, I am running into an issue. My data has a series of unique identities, split between two classes, one of which has subclasses. So far I have structured my search this way: Year | Class / \ Unique Subclass \
  3. I'm trying to create an array of data based off of the numbers contained in a filtered table. I'm not familiar with SQL, but work extensively with javascript Essentially, say I have 200 records in a table like this: Name, Date, Amount Bob, 9/16, 250 Tom, 8/16, 150 I'm trying to generate an array that would be: [ { "name": "Bob", "amount": 250 }, { "name": "Tom", "amount": 150 }, etc... ] for the entire table based on applied filters -- not just what is being displayed (which I was able to do above). I don't know enough about the guts
  4. Hrmm but obviously now that I think about it that will only pull the displayed data, and not the full data associated with a table. So back to square one I suppose.
  5. Hey never mind, I think I figured it out on my own. In the footer: var TableData = new Array(); $('#.cbResultSetTable tr').each(function(row, tr){ TableData[row]={ "Name" : $(tr).find('td:eq(0)').text() , "State" : $(tr).find('td:eq(2)').text() , "Amount" : $(tr).find('td:eq(4)').text() } }); TableData.shift(); // first row is the table header - so remove TableData.splice(-1,1); console.log(TableData);
  6. Maybe a dumb question, but is it possible generate a javascript array from tabular data contained within a datapage report? Example, I have a tabular report of 35 entries. What I'd like to do is generate a javascript array that I could then use to build an svg graphic using d3.js within a html section of the datapage. What I guess I'm wondering is, aside from me building the array through scripting, does Caspio already use arrays when creating a table and could I just piggyback off that array? Any thoughts? Thanks.
  7. I believe (I will check) that if you leave image size blank under the datapage options, it will auto-size the image respective of the page in which it is displayed.
  8. Never mind. Instead of showing/hiding the div, I used jquery to show/hide the text. Solved the issue. If anyone ever needs it: <script> $(document).ready(function(){ $('.moreinfo').hide(); $('.more').click(function (ev) { var t = ev.target $('#info' + $(this).attr('target')).toggle(500, function(){ $(t).html($(this).is(':visible')? 'I\'m done reading more' : 'Read more') }); return false; }); }); </script> <p class="moreinfo" id="info1">text text text text </p> <a class="
  9. I've been using something similar on a form. The only issue is that when you click the show/hide button, it reloads the form to the top of the page, causing users to have to scroll back down to display the div. Anyone know a way around this?
  10. I actually figured this out late last night. I just passed <ul><li>Information</li></ul> as the checkbox value, then inserted it into the email as an html value. So it auto-builds the list, and doesn't show white space where a button has not been checked. Cheers, Nick
  11. All, new user, looking for some help. I'm trying to format a notification email to generate a list based on selections a user makes on a submission form. Essentially I have 11 checkboxes, what I'm trying to do is create: <li>Checkbox1 value</li> <li>Checkbox2 value</li> <li>Checkbox3 value</li> ..etc... within the notification email, but not create <li> items for unchecked boxes. So if a user selects boxes 1 and 3, it would display as: <li>Checkbox1 value</li> <li>Checkbox3 value</li> without a bla
  • Create New...