Hi,
This should be added in the Footer of the DataPage. Make sure to disable the HTML editor first before pasting the code.
https://howto.caspio.com/datapages/datapage-components/datapage-header-and-footer/
Hi!
You can also check this article for different syntax available when displaying parameters:
https://howto.caspio.com/parameters/displaying-parameters/
Hello!
You may also want to check their Howto article on how to change the background color of the results page dynamically: https://howto.caspio.com/tech-tips-and-articles/how-to-dynamically-change-the-background-of-a-results-page/
Hi all,
Just wanted to share with you the three formulas to use when ranking records. These are working in Calculated Fields in the DataPage.
RANK()
- RANK() SQL Rank function is used to specify the rank for each row in the result set.
- Treats ties as equal but ranks will be skipped with each change in value.
RANK() OVER (PARTITION BY Request_No ORDER BY Date DESC)
ROW_NUMBER()
- ROW_Number() SQL RANK function is used to get a unique sequential number for each row in the specified data. It gives the rank one for the first row and then increments the value by one for each row. We get different ranks for the row having similar values as well.
- Does not consider ties.
ROW_NUMBER() OVER (PARTITION BY Request_No ORDER BY Date DESC)
DENSE_RANK()
- DENSE_RANK() function is used to specify a unique rank number within the partition as per the specified column value
- Treats ties as equal but ranks are not skipped with each change in value
DENSE_RANK() OVER (PARTITION BY Request_No ORDER BY Date DESC)
Please note to change the Request_No and Date fields.
Hello!
To add to the previous response, here are some helpful links regarding Triggered Actions:
https://howto.caspio.com/tables-and-views/triggered-actions/
https://www.youtube.com/watch?v=ZdkQOvLX4ok
https://www.youtube.com/watch?v=W_HbGhWrsyE
Hi!
Just to add, if you would like to select a date range, you may try the solution provided in the howto article: https://howto.caspio.com/tech-tips-and-articles/render-date-range-in-calendar-datapage/
Hi @wimtracking2,
You can disable the dropdown field using Rules. To get the value from the other DataPage, either you pass the parameter or use a Virtual Field > Calculated Value.
https://howto.caspio.com/datapages/forms/conditional-forms/
https://howto.caspio.com/datapages/datapage-components/calculated-values/
Hope this helps.
Hi!
Another option is to hide the submit button if the condition is unmet. You can add this in the Footer of the DataPage.
<script type="text/javascript">
document.addEventListener('DataPageReady', function (event) {
document.querySelector("input[name='cbParamVirtual1']").addEventListener('change', function() {
if (document.querySelector("input[name='cbParamVirtual1']").value == 'Good') {
document.getElementsByClassName('cbSubmitButtonContainer')[0].style.display = 'none';
} else {
document.getElementsByClassName('cbSubmitButtonContainer')[0].style.display = 'inline';
}
});
});
</script>
cbParamVirtual1 is the Virtual Field used for checking the data entered.
Hi all!
Sharing this script with you to hide the Submit button based on the result of a Calculated Value:
<script type="text/javascript">
document.addEventListener('DataPageReady', function (event) {
document.querySelector("input[name='cbParamVirtual1']").addEventListener('change', function() {
if (document.querySelector("input[name='cbParamVirtual1']").value == 'Good') {
document.getElementsByClassName('cbSubmitButtonContainer')[0].style.display = 'none';
} else {
document.getElementsByClassName('cbSubmitButtonContainer')[0].style.display = 'inline';
}
});
});
</script>
Hi all!
Sharing this script with you to hide the Submit button based on the result of a Calculated Value:
<script type="text/javascript">
document.addEventListener('DataPageReady', function (event) {
document.querySelector("input[name='cbParamVirtual1']").addEventListener('change', function() {
if (document.querySelector("input[name='cbParamVirtual1']").value == 'Good') {
document.getElementsByClassName('cbSubmitButtonContainer')[0].style.display = 'none';
} else {
document.getElementsByClassName('cbSubmitButtonContainer')[0].style.display = 'inline';
}
});
});
</script>
Hi!
Just to update you, you can check if the email is already existing using a Formula, then, hide the Submit button using a script. For more details, you can refer here: