Jump to content

Leaderboard

Popular Content

Showing content with the highest reputation on 10/07/2021 in all areas

  1. Tubby

    Caspio User logs

    Unfortunately there is no way to download the logs in the new UI. But you can still access the old user logs by typing this to the URL: https://<accountID>.caspio.com/ui/userlogs Just change <accountID> to your account ID which you can find in account settings.
    1 point
  2. It is possible to change the currency sign dynamically, but only with a JavaScript solution. For the Report DataPage, set the fields formatting to US dollar ('$'). Then the following code should be put in the Footer of the DataPage: Note that if you are not using all the elements in the Report as described in the code, just delete the parts using that elements. <script> document.addEventListener('DataPageReady', () => { /* Declaring the function for replacing the specific text value in some array of HTML elements */ const replacing = (obj,whatToReplace,withWhatToReplace) => { obj.forEach(record => { const modified = record.textContent.replaceAll(whatToReplace, withWhatToReplace); record.textContent = modified; }); } /* Selecting all cells where we want to replace signs */ let table = document.querySelectorAll('.cbResultSetTableCellNumberDate'); // Table cells let htmlBlocks = document.querySelectorAll('.cbResultSetTableCell'); // HTML blocks inside the table let calculated = document.querySelectorAll('.cbResultSetCalculatedField'); // Calculated values in the table let sumAggregate = document.querySelectorAll('.cbResultSetTotalsDataCellNumberDate'); // Aggregates Total let aggregate = document.querySelectorAll('.cbResultSetGroup1LabelCellNumberDate'); // Aggregates in Group-level aggregations const dollar = '$'; const euro = '€'; const pound = '£'; /* Calling the Function 'replacing' for the declared elements, with arguments, based on the authentication field */ switch('[@authfield:Localization]'){ case 'Europe': replacing(table, dollar, euro); replacing(htmlBlocks, dollar, euro); replacing(aggregate, dollar, euro); replacing(sumAggregate, dollar, euro); replacing(calculated, dollar, euro); break; case 'Britain': replacing(table, dollar, pound); replacing(htmlBlocks, dollar, pound); replacing(aggregate, dollar, pound); replacing(sumAggregate, dollar, pound); replacing(calculated, dollar, pound); break; case 'USA': // Note that this case is redundant if using the dollar as default sign replacing(table, dollar, dollar); replacing(htmlBlocks, dollar, dollar); replacing(aggregate, dollar, dollar); replacing(sumAggregate, dollar, dollar); replacing(calculated, dollar, dollar); break; } }); </script> In the case you are using the "In Line Insert", then the part with declarations of variables "table" and "htmlBlocks" should be a replaced with the following code: /* Delete the variable "htmlBlocks" and replace the declaration of variable "table" with the code */ let tableParent = document.querySelectorAll('tr[data-cb-name="data"]') let table = []; tableParent.forEach(el => { let cells = el.querySelectorAll('.cbResultSetTableCellNumberDate'); table.push.apply(table, cells); let htmlBlocks = el.querySelectorAll('.cbResultSetTableCell'); table.push.apply(table, htmlBlocks); }); Also, delete the "replacing(htmlBlocks, currency, currency)" from Switch statement in this case. The resulting Report will look something like this if the user with European localization is logged in:
    1 point
×
×
  • Create New...