Greetings!
I am wondering if someone here might be able to help me with something I have been struggling with.
I have a jotform where I am able to send the submissions to my monday board but, I am trying to figure out a way to then create subitems of the products that are individual items added by the user.
I reached out to make support and they told me to use the following scenario:
However, I am struggling to figure out where I use the spilt replace function in the create subitems part of the scenario…
Below are screenshots of the Jotform area of what I need the subitems to be taken from and also a screen shot of the monday board, the highlighted is how I would like the information to be displayed.
Uploading: Monday example.png…
Any advice is much appreciated!
@SoundTools
You don’t need a split().
Here is how I would do it…
Use this expression in your Create a subitem module where you want to place the values:
{{replace(4.value; "/\[""(.*?)"",""(.*?)"",""(.*?)""\]/"; "$1")}}
It will look something like this:
The “$1” will make it return the first parameter. Change “$1” to “$2” or “$3” for the second and third values.
Jim - The Monday Man (YouTube Channel)
What is Make & How can it help you?
We Create Custom Solutions
Schedule a 1-on-1 Tutorial Session (for monday, Make & “What is Gravity?”)
2 Likes
Hi Jim! Thank you!! Do you know what the item ID or Column ID would be mapped to? Also is you 4.Value an example or is that the exact thing I would enter?
Thank you sooo much!
So I got somewhere with that… The problem is that it is not placing the items in their sub categories. Two attachment shots below one of monday sub items and two of the scenario
@JimTheMondayMan helped me solve this, thank you so much!
Instead of the original scenario I had it was changed to the following:
Jotform (watch for submissions -->Monday (create an item) —> JSON ( used to select the item string in the jotform---->Monday (create Item) Only added Item ID and Subitem name, no arrays) ----> Monday (update column values of a specific item)
In the last Monday module, here is a screen shot of the column values added for reference:
Thank you again Jim, you helped tremendously!!
2 Likes
