| Info |
|---|
In this tutorial you will learn how to
NB, You will need https://marketplace.atlassian.com/plugins/com.atlassian.confluence.plugins.editor.confluence-source-editor plugin (free) to complete the tutorial. As you have to set the excel macro parameters using the Storage Format editor, because setting dynamic variables via macro dialog is not supported. |
| Excerpt Include | ||||||
|---|---|---|---|---|---|---|
|
Since version 1.9.20 of ConfiForms we have added support for using built-in Excel macro (and other Office documents related macros) inside ConfiForms IFTTT.
Here is how you can built a solution which accepts uploading excel files and storing them as attachments and creating a page per file to show the uploaded excel file contents.
Let's start with the ConfiForms Form definition.
We will have only one field in the form and it will be of type "File"
And the form will have an IFTTT macro rule to create a Confluence page when the record is created
The configuration for the form will look like
So, you can see we have a ConfiForms form, one registration control to enable creating new records, and a field named "excel" of type "file"
Also the form has an IFTTT macro inside which creates a page when new record is saved and shows the file uploaded using the excel macro
This is how the form looks like in view mode
The interesting and most important part is how the excel macro is configured
Let's see it contents using the storage format viewer (You will need a https://marketplace.atlassian.com/plugins/com.atlassian.confluence.plugins.editor.confluence-source-editor plugin to complete the tutorial)
The important part here is highlighted, you can see that "filename" is set to [entry.excel], which will be dynamically substituted to the uploaded file name when the page is created.
You can see that the page parameter is set to point at current page, this is important. As this link will be correctly substituted to point at original page (at current page), not at the page created
And we have also included the space parameter to set the Confluence space explicitly (we have our page in TEST space)
And the result is as follows (we have set a naming convention for created pages to "page with excel [entry.dateCreatedFormatted]", as you may see in the storage format above)
WiP...