Jump to content

Leaderboard

Popular Content

Showing content with the highest reputation since 08/23/2020 in all areas

  1. Hi @MaraMara, To move your "Record Action buttons column" to the first column you may follow the next steps: 1. Go to Styles and open the styles that you are using for the DataPage 2. Select Table Layout under Results Page 3. Under Element Type, look for Record Action Column 4. On the Position dropdown, change the position to Left. 5. Click Save then go to your DataPage then apply this Style Hope this helps!
    2 points
  2. Thanks to both of you. Learned a lot here. Great to be a new member with such helpful fellow members!
    2 points
  3. Hi - I want to hide the message 'No record found ' and the header of the DataPage.
    1 point
  4. Hi @Vitalikssssss, I replaced error message 351 in my localization file for the form with: <div id="norecord"><h3>Please add a student to continue.</h3></div> I originally used the code higher in this thread in the window.onload event and it worked to hide the buttons when the form first loaded. But due to the Ajax functionality employed when records are deleted, it did not remove the buttons when all records were deleted. So at the suggestion of @Alison I changed the code to listen for the DataPageReady event of the specific form on my page but now it
    1 point
  5. Sherif

    Update calculated field

    In a submission form, Calculated Value (formula) in a number field where; calculated failed equals field A +filed B if i enter A and B manually the result will refresh real time and update automatically if value of filed A and B inserted by java script like time stamp the result filed will not update is there any way to auto refresh the calculated filed or better to understand what is different between manual input typing and java script to insert value for example below works and put the value in field but calculated field will not refresh unless manually
    1 point
  6. Hey @taylorswiftlover, Yes, this is possible. On a table level, I have tried them using Triggered actions:
    1 point
  7. sandy159

    Excel Get data

    Hello @Sherif, To automatically send info between Caspio Cloud Database and Microsoft Excel, you will need to use Integration with Zapier. You can check the following links I found: https://howto.caspio.com/integration/zapier/ https://zapier.com/apps/caspio-cloud-database/integrations/excel Also you may check Scheduled Import and Export in Caspio: https://howto.caspio.com/tables-and-views/scheduled-import-and-export/ or you can always update you tables manually using Import/Export. Regards
    1 point
  8. Thank you Alison!
    1 point
  9. You may try this formula: CASE WHEN [@field:FirstName1] = ' ' THEN IsNull([@field:LastName1], ' ') + ' ' + IsNull([@field:FirstName2], ' ') + ' ' + IsNull([@field:LastName2], ' ') WHEN [@field:LastName1] = ' ' THEN IsNull([@field:FirstName1], ' ') + ' ' + IsNull([@field:FirstName2], ' ') + ' ' + IsNull([@field:LastName2], ' ') WHEN [@field:FirstName2] = ' ' THEN IsNull([@field:FirstName1], ' ') + ' ' + IsNull([@field:LastName1], ' ') + ' ' + IsNull([@field:LastName2], ' ') WHEN [@field:LastName2] = ' ' THEN IsNull([@field:FirstName1], ' ') + ' ' + IsNull([
    1 point
  10. Hello @Sherif, I hope that previous answer was helpful. I would like to add that it is a good approach to add the DataPageReady event. Please refer to the example: <script > document.addEventListener('DataPageReady', function (event) { document.querySelector('#InsertRecordNumber_field').type='tel'; //replace Number_field with your local field name }); </script> You may add the code to the DataPage Header or Footer section.
    1 point
  11. These links might help you on this: Getting the element: Setting up the JS code: https://www.universalwebservices.net/web-programming-resources/javascript/change-input-element-type-using-javascript/
    1 point
  12. Hi @KAPITYAN, You may try this workaround. Add a Header/Footer to your form and add the following code in the footer: <script> function setSearchIssue(){ var issue = document.querySelector('input[id*="cbParamVirtual8"]').value; document.getElementById("InsertRecordName").value = issue; } document.querySelector('input[id*="cbParamVirtual8"]').onchange = function() {setSearchIssue()}; </script> Also refer to https://forums.caspio.com/topic/4377-js-guide-caspio-form-elements/ for help on addressing different form elements.
    1 point
  13. Hi @MaraMara, To achieve this workflow you can create three separate DataPages for different Column Headers. Then, you can also create a Submission Form that will serves as your Search Form. On your Submission Form, you can add a Calculated Value that will determine what DataPage URL should your Submission/Search from will redirect after hitting the button. You may refer to these articles: https://howto.caspio.com/tech-tips-and-articles/tech-parameters/how-to-separate-search-page-and-results-page-into-two-different-webpages/ https://howto.caspio.com/function-re
    1 point
  14. Hi @DesiLogi, Perhaps you can use CSS instead of JS to hide the Datapage. Try putting this code in DP Header: <style> #caspioform { display: none; } </style>
    1 point
  15. The real answer is Caspio should just create a distinct field button of some sort like they do in dropdowns when you can check Distinct Options and Im sure it would take them 20 minutes to do and everyone could use this!
    1 point
  16. Hello @TroubleShooter, Try adding this snippet of code in the Header of your Results Page Fields: <style> td.cbResultSetActionCell.cbResultSetData *:nth-child(4n) { display: block; } </style> -DN31337!
    1 point
×
×
  • Create New...