The form I'm working on needs to calculate and populate the fiscal year based on the current date. The charges to purchase a license for the 'calculated and populated' fiscal year must populate in the fields via lookup rules.

I have used the onload function for calculating and populating the fiscal year.

However, the lookup rules take precedence over the onload function and the Charge fields are left blank.

Can I use lookup rules to pull the data from the datasource when an event occurs? Are there any other alternatives?

Regards,

Sneha