Popular Content

Showing most liked content since 08/20/2017 in all areas

  1. 1 point
    Hi Kirkman, You can try this template code inside an HTML file or HTML DataPage: <div class="forms-container" class="container-fluid"> <div class="row datapage-row"> <div class="col-md-12 col-sm-12 col-xs-12"> <!-- TODO: Put your DataPage [iframe] embed code here --> <script type="text/javascript" src="https://c2eru839.caspio.com/scripts/embed.js"></script> <!--<script type="text/javascript">try{f_cbload(true, "c2eru839.caspio.com", "148b400049998e67f1434f05bf7f");}catch(v_e){;}</script>--> <iframe name="ACBL New Profile" title="ACBL New Profile" src="https://c2eru839.caspio.com/dp.asp?AppKey=148b400049998e67f1434f05bf7f" width="100%" height="200px" style="border-style: none">Sorry, but your browser does not support frames.</iframe> </div> </div> <div class="row spacer">&nbsp;</div> <button id="add-department" style="display: inline-block !important; float: right;">Add Department</button> </div> <!-- Latest jQuery + jQuery Migrate --> <script src="https://code.jquery.com/jquery-3.2.1.js"></script> <script src="https://code.jquery.com/jquery-migrate-3.0.0.js"></script> <!-- Custom scripts --> <script> $(document).ready( function (event) { var formsContainer = $('.forms-container').last(); var addDepartmentButton = $('#add-department'); addDepartmentButton.click( function (event) { var dpClone = $('.datapage-row').last().clone(); var spacer = $('.spacer').last(); var spacerClone = spacer.clone(); spacer.after(dpClone); dpClone.after(spacerClone); } ); } ) </script> Hope this helps.
  2. 1 point

    Take photo

    Add a Footer to Configure Fields screen and click on Source button to paste this code <script> var myInput = document.getElementById('InsertRecordPicture'); function sendPic() { var file = myInput.files[0]; } myInput.addEventListener('change', sendPic, false); </script> Picture needs to be changed to the file field name.
  3. 1 point

    Hide section in list report

    Add a header to your page and use the code below: <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script> Add HTML Block above all the elements that needs be hidden, uncheck HTML Editor in advanced tab and use the code below to create buttons and start the block that needs to be hidden <input type="button" href="#" id="s[@field:ID]" Value="Show" /> <div id="b[@field:ID]"> <input type="button" href="#" id="h[@field:ID]" Value="Hide" /> At the end of the elements add another HTML Block, uncheck HTML Editor and paste this code </div> <script> $(document).ready(function(){ $('#b[@field:ID]').hide(); $('#h[@field:ID]').click( function (){$('#b[@field:ID]').hide();$('#s[@field:ID]').show();}); $('#s[@field:ID]').click( function (){$('#b[@field:ID]').show(); $('#s[@field:ID]').hide();}); }); </script> Note [@ID] in this code needs to be replaced with the unique ID you have in your table source.
  4. 1 point
    I’m trying to create a line chart that tallies monthly totals for 2 things (separate fields in the same table): customer signups and customer cancels, by month. In the data source each record is a customer with a field for the Date_Submitted (signup) and a field for Cancel_Date (if they canceled, it will be blank if they didn’t). I can do a separate chart for each of these, using either date for the Category (so I can get a monthly rollup) and a 'count' for the # of companies in the value section. But I need to combine these charts into one- so across a monthly rollup there's a 'line' for # of Date_Submitted and another 'line' for # of Cancel_Dates. The problem is that for the X axis (category) you have to choose either/or date field in order to get the chart to span by months. How can I get a rollup by month without choosing one of the date fields? How can I get a 'count' of each time Date_Submitted and Cancel_Dates fall within each month? These charts are really frustrating to work with and any help would be greatly appreciated.
  5. 1 point

    No File Chosen

    See my post similar to this where you can create your own button or make the opacity 0
  6. 1 point
    Hi, InsertRecord is missing before field names in the following lines: document.getElementById("Regular_Hours").onchange=calculate; document.getElementById("OT_Hours").onchange=calculate; You may use onblur event in order to run function onchange, also I would recommend adding one more conditions in order to check that all the values which are being used in calculation are fulfilled with data <SCRIPT LANGUAGE="JavaScript"> function calculate() { var v_hours = parseFloat(document.getElementById("InsertRecordRegular_Hours").value); var v_hoursot = parseFloat(document.getElementById("InsertRecordOT_Hours").value); var v_rates = parseFloat(document.getElementById("InsertRecordRates").value); var v_ratesot = parseFloat(document.getElementById("InsertRecordRate_OT").value); if (isNaN(v_hours) || v_hours.length<1) { v_hours = 0; }else if (isNaN(v_hoursot) || v_hoursot.length<1) { v_hoursot = 0; }else if (isNaN(v_rates) || v_rates.length<1) { v_rates = 0; }else if (isNaN(v_ratesot ) || v_ratesot.length<1) { v_ratesot = 0; } var v_amount = ((v_hours * v_rates)+(v_hoursot * v_ratesot)); if ( isNaN(v_amount)){ v_amount = ""; } document.getElementById("InsertRecordAmount").value = v_amount; } document.getElementById("InsertRecordRegular_Hours").onblur=calculate; document.getElementById("InsertRecordOT_Hours").onblur=calculate; </SCRIPT> Cheers!
  7. 1 point
    I would actually recommend you check what style your Datapage is using and then modify from there. I use Wordpress and never had this happen, but it could be something in your theme's code that can be affecting the your table. If the table displays properly in your preview via Caspio, this may be the case. There is a small chance your webpage is putting a border in each cell AND around the table itself, which sometimes makes it look like a thicker border than you intend depending on the theme
  8. 1 point
    Hi I am a newbie to Caspio and am having a problem with my datapages that i cant seem to be able to fix. I created an update datapage which I then embedded into my website. The table shows with extra borders. I have tried modifying the style to no use. Im embedding the datapage into wordpress. Can someone tell me how to remove these unwanted borders.
  9. 1 point
    Hi, Try placing css into the header of the datapage: <style> #caspioform tr { border: none !important; } #caspioform td { border: none !important; } </style> You may also place additional elements if needed. Hope that helps!
  10. 1 point

    Grid edit by default

    You can try to change the style to: <style> .cbGridCtnr > .BodyCtnr > .Table{ width: auto; } .cbGridCtnr > .HeadCtnr > .Table { width: auto; } </style>
  11. 1 point
    Hi, I have a portal where users can add items. Now the only possibility is to send a notification email after every record. Is there a way to send an email after all the work is done. Even better: I have created a report with the additions nicely printed. Would be better to send that as an email to the email in authenticationform + our own email address Help is greatly appreciated
  12. 1 point
    Hi NeoInJS, Please try using this formula: FLOOR( ( DATEDIFF(day, CONVERT(datetime, CAST(DATEPART(year, [@field:Start_Time]) AS CHAR(4)) + '-01-01', 101), [@field:Start_Time]) + ( 7 - ( ( ( ( DATEPART(day, [@field:Start_Time]) + FLOOR(13 * ((CASE WHEN DATEPART(month, [@field:Start_Time]) < 3 THEN DATEPART(month, [@field:Start_Time]) + 12 ELSE DATEPART(month, [@field:Start_Time]) END) + 1) / 5) + ((CASE WHEN DATEPART(month, [@field:Start_Time]) < 3 THEN DATEPART(year, [@field:Start_Time]) - 1 ELSE DATEPART(year, [@field:Start_Time]) END) % 100) + FLOOR(((CASE WHEN DATEPART(month, [@field:Start_Time]) < 3 THEN DATEPART(year, [@field:Start_Time]) - 1 ELSE DATEPART(year, [@field:Start_Time]) END) % 100) / 4) + FLOOR((CASE WHEN DATEPART(month, [@field:Start_Time]) < 3 THEN DATEPART(year, [@field:Start_Time]) - 1 ELSE DATEPART(year, [@field:Start_Time]) END) / 400) + 5 * ((CASE WHEN DATEPART(month, [@field:Start_Time]) < 3 THEN DATEPART(year, [@field:Start_Time]) - 1 ELSE DATEPART(year, [@field:Start_Time]) END) / 100) ) % 7 ) + 6 ) % 7 + 1 ) ) ) / 7 ) + 1 NOTES: You must replace all instances of [@field:Start_Time] with your actual field. You can test for correctness by adding a calculated field that uses DATEPART(week, [@field:Start_Time]).
  13. 1 point
    Same result with REPLACE, but i found a fix... The import (update) with text(64000) field works fine from the older '.xls' excel format, but not from an .xlsx workbook. thanks ~allen
  14. 1 point
    Just did something similar where this might help someone else. Create a list report that has the items you want, but hide them all. In the header, add "<script type="text/javascript">var count=0;</script>" to start a counter. If you want to add more values, create more values like "var countX=0;" and such Create an HTML block in the Configure Results Page Fields with a script like "<script type="text/javascript"> count++;</script>" if you want to just count how many come up, in the footer, put <script type="text/javascript"> document.write(count); </script> You can display any combination of any values by adding to the HTML block something like countX=countX+[@valuex]; Neat trick I just figured out. Now I'm able to authenticate a URL for visitors based on matching enough variable to a table results. If they don't match, the report show "0" and the script keeps the important stuff hidden. If I get something, I display the info. Validation on the fly without a form.
  15. 1 point

    Autocomplete Problem

    Hello jgorny, Welcome to Caspio forum! If I understand correctly, it is possible, but it requires several steps: Add a Virtual field, select Autocomplete form element, select your table and the Text field. Select your field, select any cascading form element, for example Cascading Text Field. Select the Virtual field in the Parent field; Select the same Lookup table; Select the Text field in Filter cascade by; Select the ID field in the Field for value. Hide the field with a Rule. Does it work for you? Also you can use a Dropdown Form element instead of AutoComplete.
  16. 0 points

    inputing multi-select values

    We have not as yet been able to fix. The new facilities just launched with ver 9.6 are almost there for us. Sadly however we need the ability to be able to select from a table/view. That feature is not on this release. We also need to be able to use it in a cascading manner. So whilst the platform is clearly advancing we don't have a solution - yet. Do wish you all the best in your hunt. If you find a solution please do let me know :-) George