Accessing Domino data using VoltFormula -
Prerequisites: Create an Object Service on Foundry that connects to your Domino database using the Domino Adapter.
Within Volt Iris, you can add VoltFormula code to Open the Domino database using the Object Service.
Example:
@FileOpenDatabase(“Recipe”; “Recipe”);
Where the first parameter is the Object Service name, and the second parameter is the Database View to Open. This implementation does not present any UI and simply opens the Domino database for subcequent access.
Since most VoltFormula database related functions work on the “Current” document, you can also specify a “key” as a third parameter to have FileOpenDatabase also select a current document. The key is a value that appears in the first sorted column of a View. If you omit the key, no document is selected.
@FileOpenDatabase(“Recipe”; “Recipe”; "Hot Chocolate);
This will open the database and select the document that has the value “Hot Chocolate” in the first sorted column.
Once the Domino Database is Open and a document is selected, other DB related functions can be used such as @GetField, @SetField, and @FileSave.
You can also use @All to retrieve all the View records, decide which one of the View records you want to make “Current”, and use the VoltFormula Javascript function, setCurrentDocument(formName, UNID), to set the current document.