Using Java to Insert into Virtual Field on Web Form

[mdupras]

Hi all --

I'm building a real estate transaction database that uses a separate web form that passes parameter to a search and report form on the same page. The idea is that when the database is initially accessed it will display a map of the most recent real estate transactions in the database; the user can then use the form to generate a new search to filter and/or expand the results. Part of search is a date range, and I'm using JavaScript to calculate a default date range of the previous 20 days for that initial view. What I'm trying to do is insert those two dates into virtual fields on the web form. But it's not working -- the JavaScript to get the dates works fine, as I've done document.write to test it, but I can't get those values to insert into the fields. Here's my code:

function dateRange()
{
var today = new Date();
var range = -20;
var startDate = new Date(today.getFullYear(), today.getMonth(), today.getDate()-0+range);
var thisMonth = today.getMonth() + 1;
var startMonth = startDate.getMonth() + 1;
var enterStartDate = startMonth + "/" + startDate.getDate() + "/" + startDate.getFullYear();
var enterEndDate = thisMonth + "/" + today.getDate() + "/" + today.getFullYear();

document.getElementById('caspioform').InsertRecordcbParamVirtual4.value = enterStartDate;
document.getElementById('caspioform').InsertRecordcbParamVirtual5.value = enterEndDate;
}
onload=dateRange;

Thanks for the help!

-- Mike

[bahar_vm]

Hi Mike,

The last two lines are not correct, use the following instead:

document.getElementById('caspioform').cbParamVirtual4.value = enterStartDate;

document.getElementById('caspioform').cbParamVirtual5.value = enterEndDate;

"InsertRecord" will only be used for regular fields not virtual fields.

Best,

Bahar M.

[mdupras]

That did the trick -- thanks so much!

-- Mike

[Aether]

Hi @mdupras, 

You can now use "Calculated field/ values and Formula field" to calculate the date range.  

Check this documentation for the list of calculation or formula you can use inside Caspio:
https://howto.caspio.com/function-reference/

https://howto.caspio.com/datapages/datapage-components/calculated-values/

https://howto.caspio.com/tables-and-views/data-types/formula-fields/

https://howto.caspio.com/datapages/reports/advanced-reporting/calculations-in-forms-and-reports/