Use value in 1 confiform field (a link) to update another field with text from link

[Kevin Gleeson]

I have a Confiform where the user inputs a link into a field e.g. 

https://Ineedtoknowsomeinfo.com/taskid=1a2b3c4d5f6g

I have another field that I want to autopopulate with just the text that appears after the "taskid=" on submission.

So when you view the form output in a table you would see:

Link : https://Ineedtoknowsomeinfo.com/taskid=1a2b3c4d5f6g

TaskId : 1a2b3c4d5f6g

Anyone know how I can do this - I have looked into IFTTT and Create/Update Entry and Regular Expressions etc but I just can't seem to get the right function/entry to make it work.

Any help greatly appreciated

[Alex Medved _ConfiForms_ · Accepted solution]

You can use something like (split and get from https://wiki.vertuna.com/display/CONFIFORMS/Virtual+functions)

url.split(=).get(1)

 (assuming your field name is called url and there is literally no other extra field is needed...)

[Kevin Gleeson]

Hi @Alex Medved _ConfiForms_ ,

Thanks, that seems like a great idea.

I added it to my IFTTT to create/update entry for event onCreated:

Parameters to be set on entry:

entryId=[entry.id] & Taskid=(TaskLink.split(=).get(1))

But I'm getting this error in the Taskid field. I'm doing something wrong but not quite sure what it is. (Probably something horrendous :) )

"Expression: [(TaskLink.split(=).get(1))] could not be calculated, Unknown operator '.' at position 10"

Thanks

[Alex Medved _ConfiForms_]

There is literally no IFTTT needed or anything like that

But if you insist on using it then the parameters would be something along these lines

entryId=[entry.id]&Taskid=[entry.TaskLink.split(=).get(1)]

Alex

[Kevin Gleeson]

Hi Alex,

That's great thanks. I knew it would be something on my end - ignored the "entry.".

The reason to push for IFTTT is more for future editing by others so there is a continuity in the creation of the form.

Thanks again - really appreciated.