Leaderboard

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!

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

Hi - I want to hide the message 'No record found ' and the header of the DataPage.

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

I’m trying to create something similar to websites that has a link that automatically opens a mailing app and already has a to address. Is this possible with Caspio? I want it to appear at the bottom of my DataPage. Any suggestion is much appreciated. Thanks!

Hey @taylorswiftlover, Yes, this is possible. On a table level, I have tried them using Triggered actions:

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

Thank you Alison!

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([

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.

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/

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.

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

The answer is, use a date diff day function. kindof like this: Hope it helps, Quack.

I tried to move the title of a chart from middle to left using Styles and CSS but no luck. Is there a workaround to do this?

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>

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!

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!