confiforms: access fields of smart multi-row

Simon November 5, 2024

Hi,

how can I access the fields of the smart multi-row field?

Created it like this: wiki.vertuna.com/display/CONFIFORMS/ConfiForms+Smart+Multi-row+-+what+it+offers+and+how+to+use+it?src=sidebar

Now I want to access it via JavaScript in IFTTT Integration Rule (onCreate, Run JavaScript).

tried something like 

 

[entry.multiRowField]

1 answer

0 votes
Alex Medved _ConfiForms_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 5, 2024

This does not sound right... (not the right way to use the IFTTT of that type)  What exactly do you want to access? A value of a field when editing or what?

Simon November 5, 2024

OnCreate (which is: submit the form) I want to process inserted data with JavaScript. I think thats the right usecase for the IFTTT, isnt it?

I can acces all fields like "Titel","Firma",... , but not the "Besucher" Fied, because it is part of a smart-row-field (look at the picture below).

[entry.Titel], [entry.Firma] .... -> works

[entry.Besucher] -> gets some IDs of the entries in the small "sub"table 

Screenshot 2024-11-06 081843.png

if you need some further explanation, let me know

Alex Medved _ConfiForms_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 5, 2024

So, you want to run some arbitrary JS after the form is submitted? 

Not really sure why would you need to do that, but to access the sub properties of multi-select smart fields (which the smart multi-row essentially is), you should do something like

[entry.Besucher.transform(Nachname).asList]

Assuming Nachname is the field in the form that the Besucher is linked to

Another option is to use the REST API and load corresponding records (you know their IDs) 

Alex

Simon November 7, 2024

Thank you Alex, this works well!

Is there a way to get all data of the smart multi-row field?
For example maybe a json object:

{"Anrede": "Mr",
"Firma": "",
"Nachname": "User1last",
"Vorname": "User1pre"
},{"Anrede": "Mrs",
"Firma": "",
"Nachname": "User2last",
"Vorname": "User2pre"
}

tried something from this page wiki.vertuna.com/display/CONFIFORMS/Virtual+functions but couldnt find something

If there isnt a way I will use 

transform(colum)

for every colum and combine it to json objects in js

Thank you!

Alex Medved _ConfiForms_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 7, 2024

Of course - just do a REST API call (you know the IDs of the records)

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events