Confiforms smart multi-row field (how to delete item automatically from the source table)

[Pat L_]

Hi,

I have table 1 (source table) which lists choices (c1, c2, etc.) after table 2 that holds a smart multi-row field linking to table 1.

How can I:

1. delete the item automatically from the source table after I remove it on table 2. (i.e. after I remove c5 from one entry of table 2, it is not automatically removed from table 1.

2. is there any way I can convert the entries of choices from table 2 to a smart dropdown field of another table (table 3)? 

For example, table 2 row:

Title: MC1

Choice: c1, c2, c3

Table 3 row:

Title: MC1 

Dropdown: with 3 values in the dropdown (c1, c2 and c3) 

Thank you in advance!

dropdown

[Alex Medved _ConfiForms_]

Hi @Pat L_ 

A little demo video on how this can be approached

Configuration (page storage format) - please note that you will need to reconfigure the smart fields to point at your page/forms

<p><a class="" href="https://community.atlassian.com/t5/Confluence-questions/Confiforms-smart-multi-row-field-how-to-delete-item/qaq-p/2910551">https://community.atlassian.com/t5/Confluence-questions/Confiforms-smart-multi-row-field-how-to-delete-item/qaq-p/2910551</a></p><p><br /></p><ac:structured-macro ac:name="confiform" ac:schema-version="1" ac:macro-id="3f1f5ee3-ab5d-4f02-b352-4e116af0b9bb"><ac:parameter ac:name="formName">table1</ac:parameter><ac:rich-text-body><p><ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" ac:macro-id="022a766d-d6c2-4375-bb17-7914f55d4153"><ac:parameter ac:name="fieldName">t</ac:parameter><ac:parameter ac:name="fieldLabel">t</ac:parameter><ac:parameter ac:name="type">text</ac:parameter></ac:structured-macro></p></ac:rich-text-body></ac:structured-macro><ac:structured-macro ac:name="confiform" ac:schema-version="1" ac:macro-id="2186fa1d-2a72-419d-9fd7-000bacdea695"><ac:parameter ac:name="formName">table2</ac:parameter><ac:rich-text-body><p><ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" ac:macro-id="759eb08a-2d46-4432-a144-cc74e58d1f16"><ac:parameter ac:name="fieldName">title</ac:parameter><ac:parameter ac:name="fieldLabel">title</ac:parameter><ac:parameter ac:name="type">text</ac:parameter></ac:structured-macro></p><p><ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" ac:macro-id="56a4a19c-c2d9-4b21-acbe-6491cd78009d"><ac:parameter ac:name="fieldName">choice</ac:parameter><ac:parameter ac:name="fieldLabel">choice</ac:parameter><ac:parameter ac:name="values">[213254183:table1]t,</ac:parameter><ac:parameter ac:name="type">smartmultirow</ac:parameter></ac:structured-macro></p><ac:structured-macro ac:name="confiform-entry-register" ac:schema-version="1" ac:macro-id="62450904-52ca-423f-9f7b-22ad2f94db25"><ac:parameter ac:name="type">Embedded</ac:parameter><ac:rich-text-body><p><br /></p></ac:rich-text-body></ac:structured-macro><p><br /></p></ac:rich-text-body></ac:structured-macro><p><br /></p><ac:structured-macro ac:name="confiform" ac:schema-version="1" ac:macro-id="4322f9ad-de12-41ff-94d6-23ab1a9f0ba7"><ac:parameter ac:name="formName">table3</ac:parameter><ac:rich-text-body><p><ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" ac:macro-id="e6d93a5e-6cd0-4c6f-999c-a3723157937a"><ac:parameter ac:name="fieldName">title1</ac:parameter><ac:parameter ac:name="fieldLabel">title1</ac:parameter><ac:parameter ac:name="values">[213254183|table2|title|false||]</ac:parameter><ac:parameter ac:name="type">smartselect</ac:parameter></ac:structured-macro></p><p><ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" ac:macro-id="9bb73332-c849-46f8-a51a-8b66532b9a2c"><ac:parameter ac:name="fieldName">choice1</ac:parameter><ac:parameter ac:name="fieldLabel">choice1</ac:parameter><ac:parameter ac:name="values">[213254183|table1|t|true||]</ac:parameter><ac:parameter ac:name="type">smartselect</ac:parameter></ac:structured-macro></p><p><ac:structured-macro ac:name="confiform-field-definition-rules" ac:schema-version="1" ac:macro-id="cb259352-bc85-449a-86f0-b088b1fbaebd"><ac:parameter ac:name="fieldName">choice1</ac:parameter><ac:parameter ac:name="values"> id.queryCount(table2:@self;title:[entry.title1] AND choice:[entry._func.asEntryRef(entry.id)]):&gt;0</ac:parameter><ac:parameter ac:name="action">Apply Filter on a field</ac:parameter><ac:parameter ac:name="actionFieldName">title1</ac:parameter></ac:structured-macro></p><ac:structured-macro ac:name="confiform-entry-register" ac:schema-version="1" ac:macro-id="aa277647-c81b-4840-95fd-e45a48f4f0d1"><ac:parameter ac:name="type">Embedded</ac:parameter><ac:rich-text-body><p><br /></p></ac:rich-text-body></ac:structured-macro><p><br /></p></ac:rich-text-body></ac:structured-macro><p><br /></p><p><br /></p>

Hope it helps

Alex 

[Pat L_]

Thank you.  @Alex Medved _ConfiForms_ I tried it and it works perfectly for my 2nd question above.

However, when I delete any choices for example c3 for MC1, c3 is not removed from table1 automatically. Is there anyway I can do it automatically? for example use IFTTT?

Thanks,

[Alex Medved _ConfiForms_]

Yes, of course - you can use the https://wiki.vertuna.com/display/CONFIFORMS/Configuring+ConfiForms+IFTTT+actions+and+rules#ConfiguringConfiFormsIFTTTactionsandrules-DeleteConfiFormsEntry to delete records

[Pat L_]

Everyting works now. Thank you again, Alex!

[Pat L_]

@Alex Medved _ConfiForms_ 

I have another question. The following rule works for a registration control or edit control:

id.queryCount(table2:@self;title:[entry.title1] AND choice:[entry.id.asEntryRef(entry.id)]):>0

However, when I add this as a filter rule for choice1 and enable inline edit on the choice1, it doesn't work in inline edit mode. - The dropdown is empty. If I do not add any filter on the choice1 field in tableview or listview, everything in table1 got listed.

It looks to me the above filter should still work but I am not sure why it doesn't.

Thanks for your advice in advance.

[Alex Medved _ConfiForms_]

Where exactly do you add this filtering expression?

[Pat L_]

[Alex Medved _ConfiForms_]

Sorry, that will never work in the ConfiForms Field macro

[Pat L_]

Ok. Thanks,

[Valerie Knapp]

Hi @Pat L_ , thanks for your post.

Please consider, if you haven't already, to check out the product documentation provided by the vendor of Confiforms here - https://wiki.vertuna.com/display/CONFIFORMS/ConfiForms+app+for+creating+forms+in+Confluence 

As this is a specific use case, I would typically advise to ask the vendor directly for help with this through a support ticket. If you don't get any replies here, I would recommend this as a next step - https://marketplace.atlassian.com/apps/1211860/confiforms-data-forms-workflows-for-confluence?hosting=cloud&tab=support 

Cheers

[Pat L_]

Thank you.