Create new thing (source info from API return text)

[brendan.a.ford]

Hello,

I have an API call returning the text in the screenshot below:

I’m wanting to make it so when a user clicks a button, bubble will create the (new) task of ‘Implement a Design Timeline’ with all the appropriate details.

I’ve started the workflow trying to gather the details in the API message using ‘:find & replace’ (and also tried ‘:extract with regex’) but I’m having trouble isolating the details following ‘assignee:’, ‘description:’, ‘due date:’, and ‘title:’, as what I’ve tried is an incomplete statement.

Aybody have any ideas please?

[brendan.a.ford]

Any help is appreciated! Thanks

[Baloshi69]

As the api call is returning a text not a json right ? …

If i was on your place, i have used :SPLIT to split the text in to multiple part by giving the \n ( EOL character , supposeing the text is returning EOL character) it would have return the text as a list of item or filed just choose the one .

[boston85719]

You are referencing the value set from the Group which is just a text…what is the actual value response provided by the API call itself?

[brendan.a.ford]

@boston85719 Late reply from me… but thanks for your input. I still haven’t found a solution - my problem is slightly different now though.

So the Group that’s displaying the API call response is listed the API call’s response as Data Type: text (which Bubble support advised me to do so I can use the :find & replace and :splitby operators to separate the response into specific, seperate RGs. This works as expected, so ideally I don’t want to change this…

Now, when I create the workflow to ‘create new thing’ (thing = task), and try to reference the API response’s text, I get an invalid expression…
Oddly enough, I check my database and see that the invalid expression actually worked and has collected that data as expected…

Does anyone know what’s going on? How can I make the expression ‘valid’ so I can deploy my changes to live?

[boston85719]

is duedate a date field or a text field? Looks like to me you have it set as a date field which is why when you are using an expression that likely evaluates to text you see the red expression

[brendan.a.ford]

Ah yes… duedate is a date type field, so that makes sense… So in this case, how do I write an expression that captures text and converts it to a date type?

[boston85719]

@brendan.a.ford unfortunately you still can not do that in Bubble.

You would need to upvote this idea I submitted to the idea board a year ago

and maybe put a forum post up with the suggestion as well and tag a product manager like @grace.hong to hopefully get some attention from Bubble about the feature necessity.

Also @grace.hong the idea board needs to be a bit easier to search or at the least make it so it searches properly. I have an idea that I submitted about convert to date from April 2023

The problem is when I search the idea board for such an idea while in the tab for my ideas I do not get shown that idea as a result

Would make it easier to share the submitted idea to other users on the forum asking about such needed features to hopefully get the idea implemented a bit more quickly.

[brendan.a.ford]

@boston85719

upvote this idea

Thanks @boston85719 - I’ve upvoted

[brendan.a.ford]

@boston85719 I’ve researched a bit and see that there’s a way to achieve this through using a JS to Bubble element, running a ‘run javascript’ workflow, then referencing “JS to Bubble’s” value. Although, currently I’m unable to make mine work…

• I have the JS to Bubble element (bubble_fn_textdate)
  

  

• My run JS workflow script:
  

  

• Then the reference to its value when creating a new thing:
  

  

My debugger unfortunately shows the JavascripttoBubble A element’s value as empty… Any ideas?

[brendan.a.ford]

In the workflow, the run javascript workflow step’s script seems to be collecting the data correctly (I think?)…

But then the workflow hits this error…

[maheshkasindi]

Post screenshot of the value you’re passing to const date in js code

[brendan.a.ford]

its a variable value, but in this case it’s “15 March 2024”. Since its variable, I’m also confused whether I should be using ‘current cells index’ as the JS elements suffix?

regex:

[maheshkasindi]

I think the code needs to look like this

const d = new Date(“Parent groups text…”);

[brendan.a.ford]

I’ve updated the run javascript script (I’ve also added the missing closing quotation mark on the dynamic line):

But now receive this error:

JS2Bubble element itself it’s showing nothing on the debugger:

and then inspecting the JS2Bubble element itself it’s showing nothing…

[maheshkasindi]

Screenshot the value of last item in the run js step

[brendan.a.ford]

[maheshkasindi]

You need to pass “d”(without quotes) to Bubble_fn, not “new date”

[brendan.a.ford]

So the run JS script now reflects the correct date! Thanks!

[boston85719]

Nice, thanks for sharing that…I’ll have to take a stab at a bit later to see if I can get it to work, if not, I know who to ask.