Jump to content


  • Posts

  • Joined

  • Last visited

Everything posted by nmalawskey

  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 \ Unique On the Caspio side, it looks like this: Radio button | Cascading Radio1 / \ Listbox1 Cascading radio2 \ Listbox2 I have created rules to hide either branch A or branch B depending on the class selection. I'm trying to get both uniques to pass a parameter to the result pages named [@UNIQUE] The DataPage Elements looks like this: Virtual 1 - radio Virtual 2 - cascade radio 1 Virtual 3 - listbox 1 Virtual 4 - cascade radio 2 Virtual 5 - listbox 2 However, only listbox 2 will pass the parameter and search successfully. My speculation is this: If a selection is not made in listbox 2, the app will only pass a blank parameter since the blank listbox 2 is overwriting any selection made in listbox 1 Any ideas?
  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 of caspio to do it, however. I'm going to try and pull apart the mapmash up, maybe there's clues in there...
  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="more" target="1">Read More</a>
  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 blank <li> element where Checkbox2 value would be inserted. I've been using: [@InsertRecordXXX] to insert the records, but can't figure out how to pass the html <li> along with that. I tried searching the forums, but no dice. Any help would be appreciated!
  • Create New...