Generating Text On Search

[reyemmaus]

Hi

 

I am new to Caspio.  I have created a datapage that tracks volunteers who are eligible to serve in a certain capacity only once per year; therefore, is there a way to generate text "Ineligible to serve" if the date of last service is within 365 days of search?

 

 

thanks

rey

[MayMusic]

As I understand you have a date field in the table and if the date is less than 365 then you want to show Ineligible to serve. When do you want to show this message? In a search form when they try to search? Can you bring an example?

[reyemmaus]

Yes, in a search report when they click Search

[MayMusic]

You can try this script on your search form in the footer of the page:

<script>
function f_search(){
var d = document.getElementById('ID OF THE DATE FIELD ON SEARCH PAGE').value;
var myDate = new Date(d);
var someDate = new Date(d);
myDate.setDate(myDate.getDate() - 365);
if (someDate  > myDate){
alert('Ineligible to serve');
return false;
}
}
document.getElementById('caspioform').onsubmit = f_search;
</script>

replace ID OF THE DATE FIELD ON SEARCH PAGE with the corresponding ID.

[reyemmaus]

Interesting, I will try this. Thanks!

[MayMusic]

Let me know how it works