Scripts also allow you to use the form register in your calculations.
Imagine a report form that has three fields: Year, Number and Document (which is used to attach the report file). The script below allows you to do a duplicate check. It accesses data from the form register and Pyrus lets you know if the report has been released before.
form.onChange(['Year', 'Report No.']) .validateAsync('Report No.', async state => { const [year, num] = state.changes; if (year.text && num.text) { const duplicates = await form.fetchSelfRegister(f => f.fieldEquals('Year', year).fieldEquals('Report No.', num), []); const firstDuplicate = duplicates.tasks[0]; if (firstDuplicate) return {errorMessage: `Report has already been released`}; } return null; });
If we now try to fill out the form with the data from an existing report, we’ll see an error message and a link to the existing report.