dear community
my setup contains two forms connected via smart multi row (f1 and f2)
(f2 id is stored in f1 smart multi row as far as ususal)
i need to display infromation from f1 at rows from f2 and with this information connected i need to edit f2. For my part i understood that i cant archieve that by using the merger, because if i aggregate i cant edit it anymore. Am i right?
Anyways i tried to merge the data and it has a strange behavier merging data formated as autonumber. it somehow creates numbers on merged f2 which arent exists.
Idea:
I have is to display(view) f1 filtered to the needed row/set of rows i want. On another view i want to display the rows of f2 corresponding to the filtered f1 view via f1 smart multi row id/f2 id.
I have no idea which elements i have to use to archieve this.
An option which came to my mind was to set an autonumber in f1 and use ifttt to write the autonumber into f2 and than i can filter both tables.
i used ifttt update confiforms entries by filter in f1 on create and it works fine if i only make ONE f2 entry.
Configuration ifttt i used:
Parameters to set on the entry
field=[entry.autonumber]
Filter to apply before update
id:[entry.smart multi row]
i think it has something to do with "array" or the way the data is stored in the smartmultirow but i stuck at this point.
I need to tell him he should filter f2 id to a "list" and write the autonumber to every row.
If there are other more valid ways to archive my goal im open to it.
Code for Answer1:
<p>
<br/>
</p>
<ac:structured-macro ac:macro-id="efdbed04-f0b0-4df0-b9d0-b14f10e67b89" ac:name="confiform" ac:schema-version="1">
<ac:parameter ac:name="formName">f1</ac:parameter>
<ac:parameter ac:name="registrationFormTitle">f1</ac:parameter>
<ac:rich-text-body>
<p>
<ac:structured-macro ac:macro-id="69e80f96-8967-41bc-bbca-8422c065e187" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">uniqueid</ac:parameter>
<ac:parameter ac:name="fieldLabel">uniqueid</ac:parameter>
<ac:parameter ac:name="values">id:000</ac:parameter>
<ac:parameter ac:name="type">auto</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="7a62398f-6c82-425a-bb3e-9b7168163b58" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">f1a1</ac:parameter>
<ac:parameter ac:name="fieldLabel">f1a1</ac:parameter>
<ac:parameter ac:name="type">text</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="5ad31581-fb44-4bb3-b195-62005a7f4f66" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">f1a2</ac:parameter>
<ac:parameter ac:name="fieldLabel">f1a2</ac:parameter>
<ac:parameter ac:name="type">text</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="d267e42b-6fa3-4b49-91f4-501ad50519ac" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">f1a3</ac:parameter>
<ac:parameter ac:name="fieldLabel">f1a3</ac:parameter>
<ac:parameter ac:name="values">[345974491:f2]f2a1,f2a2,</ac:parameter>
<ac:parameter ac:name="extras">card</ac:parameter>
<ac:parameter ac:name="type">smartmultirow</ac:parameter>
</ac:structured-macro>
</p>
<p>
<br/>
</p>
<ac:structured-macro ac:macro-id="cafea251-af22-4f9c-bae1-ebe8a359ffcc" ac:name="confiform-entry-register" ac:schema-version="1">
<ac:parameter ac:name="formName">f1</ac:parameter>
<ac:parameter ac:name="type">Embedded</ac:parameter>
<ac:rich-text-body>
<p>
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<p class="auto-cursor-target">
<br/>
</p>
<p class="auto-cursor-target">this rule only works if i only create ONE entry in the smart multi row f1a3, i think it has something to do with the array how can i solve that?</p>
<ac:structured-macro ac:macro-id="cf6838e6-9525-4d79-8c0e-052303e7d35b" ac:name="confiform-ifttt" ac:schema-version="1">
<ac:parameter ac:name="action">Update ConfiForms entries by filter</ac:parameter>
<ac:parameter ac:name="event">onCreated</ac:parameter>
<ac:parameter ac:name="title">uniqueid=[entry.uniqueid]</ac:parameter>
<ac:parameter ac:name="extras2">id:[entry.f1a3]</ac:parameter>
<ac:parameter ac:name="who">f2</ac:parameter>
<ac:rich-text-body>
<p>
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<p class="auto-cursor-target">
<br/>
</p>
<p class="auto-cursor-target">
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<p>
<br/>
</p>
<p>
<br/>
</p>
<ac:structured-macro ac:macro-id="b3d356c9-7f07-498a-b186-44922267f360" ac:name="confiform" ac:schema-version="1">
<ac:parameter ac:name="formName">f2</ac:parameter>
<ac:parameter ac:name="registrationFormTitle">f2</ac:parameter>
<ac:rich-text-body>
<p>
<ac:structured-macro ac:macro-id="96d44e1c-bc51-4def-9bb9-8ade88392295" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">f2a1</ac:parameter>
<ac:parameter ac:name="fieldLabel">f2a1</ac:parameter>
<ac:parameter ac:name="type">text</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="1201dd15-b65b-4ce1-96a5-0ebca79364d2" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">f2a2</ac:parameter>
<ac:parameter ac:name="fieldLabel">f2a2</ac:parameter>
<ac:parameter ac:name="type">text</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="28eddde1-bf12-4f1a-b9be-c5489e2f7279" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">f2a3</ac:parameter>
<ac:parameter ac:name="fieldLabel">f2a3</ac:parameter>
<ac:parameter ac:name="type">text</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="62b7ad39-074c-4d39-ac27-f67bf328bf5f" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">f2a4</ac:parameter>
<ac:parameter ac:name="fieldLabel">f2a4</ac:parameter>
<ac:parameter ac:name="type">text</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="ae0b795b-2599-4dbc-a0ce-3219a7b7e888" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">f2a5</ac:parameter>
<ac:parameter ac:name="fieldLabel">f2a5</ac:parameter>
<ac:parameter ac:name="type">text</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="50e3c44d-a154-4afc-a38e-c09e090e2db9" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">uniqueid</ac:parameter>
<ac:parameter ac:name="fieldLabel">uniqueid</ac:parameter>
<ac:parameter ac:name="type">text</ac:parameter>
</ac:structured-macro>
</p>
<p>
<br/>
</p>
<p>
<ac:structured-macro ac:macro-id="d634bc3e-62e2-45ad-86e0-ba32bcd5128c" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">f1a3</ac:parameter>
<ac:parameter ac:name="fieldLabel">f1a3</ac:parameter>
<ac:parameter ac:name="type">text</ac:parameter>
</ac:structured-macro>
</p>
<p>
<br/>
</p>
<p>in my world i need this rule to connect both tables inside the merger aslong i dont use the rule in the f1</p>
<ac:structured-macro ac:macro-id="9baa1d07-929b-4b81-9cd8-332ed87dc727" ac:name="confiform-ifttt" ac:schema-version="1">
<ac:parameter ac:name="action">Create ConfiForms Entry</ac:parameter>
<ac:parameter ac:name="event">onCreated</ac:parameter>
<ac:parameter ac:name="title">entryId=[entry.id] & f1a3=[entry.id]</ac:parameter>
<ac:rich-text-body>
<p>
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<p>
<br/>
</p>
<p>
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<p class="auto-cursor-target">
<br/>
</p>
<p class="auto-cursor-target">
<br/>
</p>
<p class="auto-cursor-target">
<br/>
</p>
<ac:structured-macro ac:macro-id="728f5375-4ba4-4839-a546-2714d791938c" ac:name="confiform-table-merger" ac:schema-version="1">
<ac:parameter ac:name="flattenEntries">true</ac:parameter>
<ac:rich-text-body>
<p>strange behaviour with autonumber, he creates entries for form2 even if they are not there </p>
<p>
<br/>
</p>
<p>
<br/>
</p>
<p>
<br/>
</p>
<p>
<ac:structured-macro ac:macro-id="02b5ddf4-ad7c-4533-ac62-4441a070c9b2" ac:name="confiform-field" ac:schema-version="1">
<ac:parameter ac:name="fieldName">f1a3</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="ac410aaa-d0be-4ed5-9c3a-cd9fce3e652a" ac:name="confiform-field" ac:schema-version="1">
<ac:parameter ac:name="fieldName">attributef2a2:([entry.f2a2])</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="ef53fd74-3f53-4e02-a9fb-3172e405adc9" ac:name="confiform-field" ac:schema-version="1">
<ac:parameter ac:name="fieldName">myidf1:([entry.uniqueid])</ac:parameter>
</ac:structured-macro>
</p>
<p>
<br/>
</p>
<ac:structured-macro ac:macro-id="f2e7ae32-e472-4830-8e79-fa313f095865" ac:name="confiform-table" ac:schema-version="1">
<ac:parameter ac:name="formName">f1</ac:parameter>
<ac:rich-text-body>
<p>
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<p class="auto-cursor-target">
<br/>
</p>
<ac:structured-macro ac:macro-id="ea7e22a1-fa95-4292-9adc-b8036dcde366" ac:name="confiform-table" ac:schema-version="1">
<ac:parameter ac:name="formName">f2</ac:parameter>
<ac:rich-text-body>
<p>
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<p class="auto-cursor-target">
<br/>
</p>
<p class="auto-cursor-target">
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<p class="auto-cursor-target">
<br/>
</p>
<p class="auto-cursor-target">
<br/>
</p>
<p class="auto-cursor-target">
<br/>
</p>
<p class="auto-cursor-target">Idea to solve the Problem:</p>
<p class="auto-cursor-target">I like to filter the first table and the second table should only show the corresponding rows. I have no idea if and if yes how it is posible to filter the second table by a list of f1a3 id's from table1 after table1 got filtered.</p>
<p class="auto-cursor-target">
<br/>
</p>
<p class="auto-cursor-target">My Idea was to create another attribute in f2. This attribute is set by an ifttt in f1 and contains the uniqueid from f1.(not realized in here)</p>
<p class="auto-cursor-target">
<br/>
</p>
<p class="auto-cursor-target">
<br/>
</p>
<p class="auto-cursor-target">
<span style="color: rgb(23,43,77);">
<span> </span>ifttt update confiforms entries by filter in f1 on create<span> </span>
</span>
</p>
<p class="auto-cursor-target">
<span style="color: rgb(23,43,77);">
<span>F1Table</span>
</span>
</p>
<ac:structured-macro ac:macro-id="efc374fd-b1a7-4f08-a7c7-b1a502b444f8" ac:name="confiform-table" ac:schema-version="1">
<ac:parameter ac:name="formName">f1</ac:parameter>
<ac:parameter ac:name="enableSearch">true</ac:parameter>
<ac:rich-text-body>
<p>
<ac:structured-macro ac:macro-id="fd03dd3c-c84c-479e-a754-aaf94a0c2d0c" ac:name="confiform-field" ac:schema-version="1">
<ac:parameter ac:name="fieldName">uniqueid</ac:parameter>
</ac:structured-macro>
</p>
<p>
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<p class="auto-cursor-target">
<br/>
</p>
<p class="auto-cursor-target">F2Table</p>
<ac:structured-macro ac:macro-id="c9cbb35c-a6a1-4e20-81ea-e0c68780e6fb" ac:name="confiform-table" ac:schema-version="1">
<ac:parameter ac:name="formName">f2</ac:parameter>
<ac:parameter ac:name="enableGridEdit">true</ac:parameter>
<ac:rich-text-body>
<p>
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<p class="auto-cursor-target">
<br/>
</p>
<p class="auto-cursor-target">
<br/>
</p>
<p class="auto-cursor-target">
<br/>
</p>
HI @Timo and welcome to this community
Could you tell me what are you trying to do - is it to show the data only? I just cannot understand how the ConfiForms IFTTT macros are engaged here and why
Also, may be you can show visuals or share the configuration that you have - it is very difficult to understand what you are trying to do and how the forms are related
Alex
Hi Alex,
first of all thx to the fast response, and sry for the bad english.
because my codeblock is somehow deleted as reply, i put it into the question section.
i have tried to recreate the problem with some abstract forms.
also i have tried to put some information inside the code block, may its helpful.
Im trying to explain my Problem in another way.
i plan to collect the information with form1(f1). in form 1 is a field with type smart multi row, which has a subset of the fields from form2(f2). after i collected the information i want to edit the entries from form2 by another user who has access to all fields, but i need some information from form1 to know, to which form1 entry the form2 entry belongs.
i cant archieve this with the merge function because i cant edit it anymore after the aggregation. nevertheless i have tried to create a table like this and i found out, that there is a problem when one of the fields are formated as autonumber. it seesm to create also autonumbers for every row in form2 even if it not exits in the original form.
to get rid of this, i tried to put an field as uniqueid(autonumber) created in form1 to every entry in form2 which is created by the smart multi row. Thats the point where the ifttt of form1 doesnt work like i want, because it creates an entry in form2 only for ONE smart multi row but not for more than ONE smart multi row entries.
if i can set the uniqueid into the corresponding entry from form2 than i can filter both tables by the same value and i got the matched entries from both tables.
or is there an easier way to show 2 tables, which are connected by smart multi row where table2 is editable and only shows the corresponding entreis from the fitered table1
thx alot for helping
Timo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Consider the following configuration
<ac:structured-macro ac:macro-id="efdbed04-f0b0-4df0-b9d0-b14f10e67b89" ac:name="confiform" ac:schema-version="1">
<ac:parameter ac:name="formName">f1</ac:parameter>
<ac:parameter ac:name="registrationFormTitle">f1</ac:parameter>
<ac:rich-text-body>
<p>
<ac:structured-macro ac:macro-id="7a62398f-6c82-425a-bb3e-9b7168163b58" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">f1a1</ac:parameter>
<ac:parameter ac:name="fieldLabel">f1a1</ac:parameter>
<ac:parameter ac:name="type">text</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="5ad31581-fb44-4bb3-b195-62005a7f4f66" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">f1a2</ac:parameter>
<ac:parameter ac:name="fieldLabel">f1a2</ac:parameter>
<ac:parameter ac:name="type">text</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="d267e42b-6fa3-4b49-91f4-501ad50519ac" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">f1a3</ac:parameter>
<ac:parameter ac:name="fieldLabel">f1a3</ac:parameter>
<ac:parameter ac:name="values">[345974491:f2]f2a1,f2a2,</ac:parameter>
<ac:parameter ac:name="extras">card</ac:parameter>
<ac:parameter ac:name="type">smartmultirow</ac:parameter>
</ac:structured-macro>
</p>
<p>
<br/>
</p>
<ac:structured-macro ac:macro-id="cafea251-af22-4f9c-bae1-ebe8a359ffcc" ac:name="confiform-entry-register" ac:schema-version="1">
<ac:parameter ac:name="formName">f1</ac:parameter>
<ac:parameter ac:name="type">Embedded</ac:parameter>
<ac:rich-text-body>
<p>
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<ac:structured-macro ac:macro-id="7c186fc5-7340-43f4-916b-beb93840ccb3" ac:name="confiform-ifttt" ac:schema-version="1">
<ac:parameter ac:name="action">Update ConfiForms entries by filter</ac:parameter>
<ac:parameter ac:name="event">onCreated</ac:parameter>
<ac:parameter ac:name="title">f1a3=[entry.id]</ac:parameter>
<ac:parameter ac:name="extras2">id:[entry.f1a3.transform(id).join( OR id:)]</ac:parameter>
<ac:parameter ac:name="who">f2</ac:parameter>
<ac:rich-text-body>
<p>
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<p class="auto-cursor-target">
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<p>
<br/>
</p>
<p>
<br/>
</p>
<ac:structured-macro ac:macro-id="b3d356c9-7f07-498a-b186-44922267f360" ac:name="confiform" ac:schema-version="1">
<ac:parameter ac:name="formName">f2</ac:parameter>
<ac:parameter ac:name="registrationFormTitle">f2</ac:parameter>
<ac:rich-text-body>
<p>
<ac:structured-macro ac:macro-id="96d44e1c-bc51-4def-9bb9-8ade88392295" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">f2a1</ac:parameter>
<ac:parameter ac:name="fieldLabel">f2a1</ac:parameter>
<ac:parameter ac:name="type">text</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="1201dd15-b65b-4ce1-96a5-0ebca79364d2" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">f2a2</ac:parameter>
<ac:parameter ac:name="fieldLabel">f2a2</ac:parameter>
<ac:parameter ac:name="type">text</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="28eddde1-bf12-4f1a-b9be-c5489e2f7279" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">f2a3</ac:parameter>
<ac:parameter ac:name="fieldLabel">f2a3</ac:parameter>
<ac:parameter ac:name="type">text</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="62b7ad39-074c-4d39-ac27-f67bf328bf5f" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">f2a4</ac:parameter>
<ac:parameter ac:name="fieldLabel">f2a4</ac:parameter>
<ac:parameter ac:name="type">text</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="ae0b795b-2599-4dbc-a0ce-3219a7b7e888" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">f2a5</ac:parameter>
<ac:parameter ac:name="fieldLabel">f2a5</ac:parameter>
<ac:parameter ac:name="type">text</ac:parameter>
</ac:structured-macro>
</p>
<p>
<br/>
</p>
<p>--- this one is to store ref to f1</p>
<p>
<ac:structured-macro ac:macro-id="71fb08a0-d1f9-4001-842b-9bcef76f8f72" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">f1a3</ac:parameter>
<ac:parameter ac:name="fieldLabel">f1a3</ac:parameter>
<ac:parameter ac:name="values">[157942036|f1|f1a1|true||]</ac:parameter>
<ac:parameter ac:name="type">smartselect</ac:parameter>
</ac:structured-macro>
</p>
<p>
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<p class="auto-cursor-target">
<br/>
</p>
<p class="auto-cursor-target">
<br/>
</p>
<p class="auto-cursor-target">
<br/>
</p>
<ac:structured-macro ac:macro-id="ea7e22a1-fa95-4292-9adc-b8036dcde366" ac:name="confiform-table" ac:schema-version="1">
<ac:parameter ac:name="formName">f2</ac:parameter>
<ac:rich-text-body>
<p>
<ac:structured-macro ac:macro-id="02b5ddf4-ad7c-4533-ac62-4441a070c9b2" ac:name="confiform-field" ac:schema-version="1">
<ac:parameter ac:name="fieldName">f1a3</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="bc23ebbc-fbdb-4bcd-8a25-b2f03f68965e" ac:name="confiform-field" ac:schema-version="1">
<ac:parameter ac:name="fieldName">f2a1</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="afc161de-0a0a-4792-8fb0-8e0f061a14cc" ac:name="confiform-field" ac:schema-version="1">
<ac:parameter ac:name="fieldName">f2a2</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="df32a4b8-05f4-4854-b18f-6df2e8145db5" ac:name="confiform-field" ac:schema-version="1">
<ac:parameter ac:name="fieldName">f2a3</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="26b3b6b0-6a04-43f6-9bb1-87ed23c0e421" ac:name="confiform-field" ac:schema-version="1">
<ac:parameter ac:name="fieldName">f2a4</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="72c95635-5c65-46a2-87b7-0cab0b5bc9a7" ac:name="confiform-field" ac:schema-version="1">
<ac:parameter ac:name="fieldName">f2a5</ac:parameter>
</ac:structured-macro>
</p>
<ac:structured-macro ac:macro-id="2f01ac30-b2a9-479c-9fef-8fab3355225c" ac:name="confiform-entry-edit" ac:schema-version="1">
<ac:rich-text-body>
<p>
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
Alex
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Alex,
that's too bad, i was so close to the solution, i already saw the point on split function here:
Virtual functions - Vertuna WIKI - ConfiForms
And i already thought it's the solution for my problem but i removed the transform part because i thought a join would be enough and to be honest i didnt understood the function of transform here.
But i imagine the transform(id) means something like get the id's out of my string and than join the array.
At the end of your Code is another:
</ac:rich-text-body>
</ac:structured-macro>
missing, but than it works like i need to and i can transform it to my problem.
rly Thx alot for that.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Alex,
i got another Problem on this thing.
u put an id into the f1a3:
f1a3=[entry.id]
for the ifttt and with the id it works fine.
But if i want to put autonumber into the filed by "Update ConfiForms entries by filter" than it writes the number into the filed f1a3 but not that way it should.
If i use a view on that table f2 i can see the autonumber filled in but if i edit the entry it says there ist no value, but i can selsec it by the drop down. also if i try to filter for the autonumber it ignores the entry filled by ifttt if its an autonumber filed.
and yes i switched f1a3 from referenceing on an id to the autonumber.
u have any ideas whats wrong in this case with the auto number?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I dont understand this to be honest
But you cannot edit the autonumber field or any "auto" fields... as they get their values "automatically"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Alex,
nearly. i can edit it after it got filled with an autonumber by an ifttt. but with the autonumber its seems not to be consistent, something like if i write data to an database and don't "commit" it, so that they are in the buffer but other applications cant see them. I dont know how to explain it in another way.
i try to make it more clear with screenshots
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Honestly, I have no idea what this is - but what I can say is that you never should change or attempt to change the auto fields in ConfiForms yourself
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Alex,
u have no idea why this failure happens, or what i try to explain?
Because i dont try to change the autonumber created by confiforms.
What im doing is:
I got a form f1 with an autonumber and a smartmultirow field.
If i make an entry in in f1 it creates the autonumber an with the ifttt i put the autonumber in a field from f2 entries created by the smartmultirows.
If i do so, the autonumber appears in the table view for f2 but i cant filter for it. also if i edit the rows from f2 the field with the referencing autonumber is not preselected.
i will put the code into the next reply:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
<p>
<br/>
</p>
<ac:structured-macro ac:macro-id="efdbed04-f0b0-4df0-b9d0-b14f10e67b89" ac:name="confiform" ac:schema-version="1">
<ac:parameter ac:name="formName">f1</ac:parameter>
<ac:parameter ac:name="registrationFormTitle">f1</ac:parameter>
<ac:rich-text-body>
<p>
<ac:structured-macro ac:macro-id="668d8b72-e0a2-40f2-a003-4e70033fb9e8" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">autoid</ac:parameter>
<ac:parameter ac:name="fieldLabel">autoid</ac:parameter>
<ac:parameter ac:name="values">Kapa:0001</ac:parameter>
<ac:parameter ac:name="type">auto</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="7a62398f-6c82-425a-bb3e-9b7168163b58" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">f1a1</ac:parameter>
<ac:parameter ac:name="fieldLabel">f1a1</ac:parameter>
<ac:parameter ac:name="type">text</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="5ad31581-fb44-4bb3-b195-62005a7f4f66" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">f1a2</ac:parameter>
<ac:parameter ac:name="fieldLabel">f1a2</ac:parameter>
<ac:parameter ac:name="type">text</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="d267e42b-6fa3-4b49-91f4-501ad50519ac" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">f1a3</ac:parameter>
<ac:parameter ac:name="fieldLabel">f1a3</ac:parameter>
<ac:parameter ac:name="values">[345974491:f2]f2a1,f2a2,</ac:parameter>
<ac:parameter ac:name="extras">card</ac:parameter>
<ac:parameter ac:name="type">smartmultirow</ac:parameter>
</ac:structured-macro>
</p>
<p>
<br/>
</p>
<ac:structured-macro ac:macro-id="cafea251-af22-4f9c-bae1-ebe8a359ffcc" ac:name="confiform-entry-register" ac:schema-version="1">
<ac:parameter ac:name="formName">f1</ac:parameter>
<ac:parameter ac:name="type">Embedded</ac:parameter>
<ac:rich-text-body>
<p>
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<p class="auto-cursor-target">
<br/>
</p>
<ac:structured-macro ac:macro-id="dda9d5ab-f1f1-4185-81c1-6674a63b9363" ac:name="confiform-ifttt" ac:schema-version="1">
<ac:parameter ac:name="action">Update ConfiForms entries by filter</ac:parameter>
<ac:parameter ac:name="event">onCreated</ac:parameter>
<ac:parameter ac:name="title">f1a3=[entry.autoid]</ac:parameter>
<ac:parameter ac:name="extras2">id:[entry.f1a3.transform(id).join( OR id:)]</ac:parameter>
<ac:parameter ac:name="who">f2</ac:parameter>
<ac:rich-text-body>
<p>
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<p class="auto-cursor-target">
<br/>
</p>
<p class="auto-cursor-target">
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<p>
<br/>
</p>
<p>
<br/>
</p>
<ac:structured-macro ac:macro-id="b3d356c9-7f07-498a-b186-44922267f360" ac:name="confiform" ac:schema-version="1">
<ac:parameter ac:name="formName">f2</ac:parameter>
<ac:parameter ac:name="registrationFormTitle">f2</ac:parameter>
<ac:rich-text-body>
<p>
<ac:structured-macro ac:macro-id="96d44e1c-bc51-4def-9bb9-8ade88392295" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">f2a1</ac:parameter>
<ac:parameter ac:name="fieldLabel">f2a1</ac:parameter>
<ac:parameter ac:name="type">text</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="1201dd15-b65b-4ce1-96a5-0ebca79364d2" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">f2a2</ac:parameter>
<ac:parameter ac:name="fieldLabel">f2a2</ac:parameter>
<ac:parameter ac:name="type">text</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="28eddde1-bf12-4f1a-b9be-c5489e2f7279" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">f2a3</ac:parameter>
<ac:parameter ac:name="fieldLabel">f2a3</ac:parameter>
<ac:parameter ac:name="type">text</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="62b7ad39-074c-4d39-ac27-f67bf328bf5f" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">f2a4</ac:parameter>
<ac:parameter ac:name="fieldLabel">f2a4</ac:parameter>
<ac:parameter ac:name="type">text</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="ae0b795b-2599-4dbc-a0ce-3219a7b7e888" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">f2a5</ac:parameter>
<ac:parameter ac:name="fieldLabel">f2a5</ac:parameter>
<ac:parameter ac:name="type">text</ac:parameter>
</ac:structured-macro>
</p>
<p>
<br/>
</p>
<p>--- this one is to store ref to f1</p>
<p>
<ac:structured-macro ac:macro-id="da01475e-37e6-47a6-bd8b-a25bb9d91b4a" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">f1a3</ac:parameter>
<ac:parameter ac:name="fieldLabel">f1a3</ac:parameter>
<ac:parameter ac:name="values">[345974491|f1|autoid|true||]</ac:parameter>
<ac:parameter ac:name="type">smartselect</ac:parameter>
</ac:structured-macro>
</p>
<p>
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<p class="auto-cursor-target">
<br/>
</p>
<ac:structured-macro ac:macro-id="77868ff8-c16e-400b-b860-92fb198c6a47" ac:name="confiform-entry-filter" ac:schema-version="1">
<ac:parameter ac:name="formName">f2</ac:parameter>
<ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
<ac:rich-text-body>
<p>
<ac:structured-macro ac:macro-id="1e55292c-4f7a-4f7c-b532-8765a13b2830" ac:name="confiform-field" ac:schema-version="1">
<ac:parameter ac:name="fieldName">f1a3</ac:parameter>
</ac:structured-macro>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<p class="auto-cursor-target">
<br/>
</p>
<p class="auto-cursor-target">
<br/>
</p>
<ac:structured-macro ac:macro-id="c54e7a4a-b950-4698-8bed-fa7b01f0f60b" ac:name="confiform-table" ac:schema-version="1">
<ac:parameter ac:name="enableFilterSupport">true</ac:parameter>
<ac:parameter ac:name="formName">f2</ac:parameter>
<ac:parameter ac:name="limit">10</ac:parameter>
<ac:parameter ac:name="sort">created DESC</ac:parameter>
<ac:rich-text-body>
<p>
<ac:structured-macro ac:macro-id="02b5ddf4-ad7c-4533-ac62-4441a070c9b2" ac:name="confiform-field" ac:schema-version="1">
<ac:parameter ac:name="fieldName">f1a3</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="bc23ebbc-fbdb-4bcd-8a25-b2f03f68965e" ac:name="confiform-field" ac:schema-version="1">
<ac:parameter ac:name="fieldName">f2a1</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="afc161de-0a0a-4792-8fb0-8e0f061a14cc" ac:name="confiform-field" ac:schema-version="1">
<ac:parameter ac:name="fieldName">f2a2</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="df32a4b8-05f4-4854-b18f-6df2e8145db5" ac:name="confiform-field" ac:schema-version="1">
<ac:parameter ac:name="fieldName">f2a3</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="26b3b6b0-6a04-43f6-9bb1-87ed23c0e421" ac:name="confiform-field" ac:schema-version="1">
<ac:parameter ac:name="fieldName">f2a4</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="72c95635-5c65-46a2-87b7-0cab0b5bc9a7" ac:name="confiform-field" ac:schema-version="1">
<ac:parameter ac:name="fieldName">f2a5</ac:parameter>
</ac:structured-macro>
</p>
<ac:structured-macro ac:macro-id="2f01ac30-b2a9-479c-9fef-8fab3355225c" ac:name="confiform-entry-edit" ac:schema-version="1">
<ac:rich-text-body>
<p>
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<p class="auto-cursor-target">
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<p class="auto-cursor-target">
<br/>
</p>
<p class="auto-cursor-target">
<br/>
</p>
<p class="auto-cursor-target">
<br/>
</p>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You set the "f1a3" field to some numeric value from the first form
But the "f1a3" is a smart dropdown and it expects a UUID of the record it is referencing
Instead of f1a3=[entry.autoid] set f1a3=[entry.id]
Honestly... if you look at my demo configuration for you - it already had the correct settings. Not sure why you switched to something else... and now struggle to get things to work
Alex
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Alex,
it seems that i missunderstood/ignored the idea of the uuid and how that functioned with the smart dropdown but i got it now, thx again!
Timo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.