How do you set up connection for storing confiforms data to database using IFTTT macro ?

[Joe66]

Hey @Alex Medved _ConfiForms_ ,

I was trying to use confiform's IFTTT macro feature to copy confiforms data to database. 
However, If i click on the Manage Connections button, I am getting an error stating that I do not have sufficient permissions to access "/admin/vertuna/confiforms/config.action". I'm also the admin for my confluence space. Do I require any other permissions besides confluence space admin?

Thanks.

[Alex Medved _ConfiForms_ · Accepted solution]

Hi @Joe66 

You need to be Confluence administrator to define a database connection

This is by design, as we want your Confluence administrators be in control and aware

Alex

[Joe66]

Thanks Alex!!
Also, I have a Confiform TableView macro with column name 'Description' of field type textarea.

Is it possible to add scrollbar to the table cells in that particular column if the content gets too long ?

[Alex Medved _ConfiForms_]

You can use the truncWithExpand function probably - https://wiki.vertuna.com/display/CONFIFORMS/Virtual+functions

[Joe66]

Thanks Alex. I tried this. However, i'm facing errors when using this virtual function with ifttt feature.

Event: onModified
Choose action: Create/Update confiform entry
Fire IFTTT Action: !description:[empty]
Parameters to set: entryId[entry.id]&description([entry.description.truncWithExpand(50)])

I actually have 4 fields- date, name, order,description

In TableViewMacro, Whenever i try to modify a cell in description field I end up getting 'date field required to be set','name field required to be set', 'order field required to be set' despite having values already filled for those fields.

Just want to make use of this truncWithExpand incase any cell content in description field gets too long. 

Am i doing something wrong in parameters to set or anywhere? Any help would be appreciated. 

[Alex Medved _ConfiForms_]

Oh, this is way too complicated and in a totally wrong direction

All I have tried to say is that you can configure a view (a TableView for example) and put a ConfiForms field where you set it's field name parameter to

description.truncWithExpand(50)

That's it

Alex

[Joe66]

This worked. Thank you !!