Hi there. I thought I'd share this one here. It is something that may be obvious to most users as it is a core concept of Velixo functions, but since it was confusing to someone we had a call with, it's worth documenting for the community.
You can easily find out which fields are required or optional in any Velixo function by looking at the function tooltip and spotting those parameters wrapped around square brackets.
In this below example:
ConnectionName, Journal and PostingDate are required parameters
but every other parameter is optional, such as: [ReverseDate], [JournalDescription]
Since some of the Velixo Writeback functions include many columns, it's important to understand that it was designed this way for flexibility purposes (you can use those if you have the need) but most parameters are in fact optional, meaning they can remain blank (with no value).
1 Votes
1 Comments
B
Ben Perryposted
7 days ago
Old thread, but just wanted to point out that this doesn't seem to be the case for all functions unfortunately.
The functions I've looked at so far in Excel for Mac show the square brackets around ConnectionName and some of the other parameters indicating optional yet the documentation says they're required.
Not sure if this is just a mistake with the Velixo Add-In (2024.11.183) for Excel on macOS.
1 Votes
Hi there. I thought I'd share this one here. It is something that may be obvious to most users as it is a core concept of Velixo functions, but since it was confusing to someone we had a call with, it's worth documenting for the community.
You can easily find out which fields are required or optional in any Velixo function by looking at the function tooltip and spotting those parameters wrapped around square brackets.
In this below example:
Since some of the Velixo Writeback functions include many columns, it's important to understand that it was designed this way for flexibility purposes (you can use those if you have the need) but most parameters are in fact optional, meaning they can remain blank (with no value).
1 Votes
1 Comments
Ben Perry posted 7 days ago
Old thread, but just wanted to point out that this doesn't seem to be the case for all functions unfortunately.
The functions I've looked at so far in Excel for Mac show the square brackets around ConnectionName and some of the other parameters indicating optional yet the documentation says they're required.
Not sure if this is just a mistake with the Velixo Add-In (2024.11.183) for Excel on macOS.
0 Votes
Login or Sign up to post a comment