How to save entire URL to database

[iamjoshgreen]

I have an input field where a user enters a website URL. In the workflow upon button click it creates a new thing in the database and saves the value of the input field to a data field that is a type text but it will only save the first part of the URL, nothing after a “/”

Example: url = www.testingapp.com/wrapthis

The URL field will only save [www.testingapp.com] and not [www.testingapp.com/wrapthis]

I can not for the life of me figure out how to save the entire url. Does anyone know why this is happening?

[msgiblin]

I just tried this out on my app and had no issues saving a full URL, with slugs & everything - a total of 3x slashes, multiple ‘?’ and slug info, and all carried through exactly like I input. Can you make sure your text input field is also type text? I saw you mentioned the database type is already type text but couldn’t hurt to confirm that too. That’s the only thing I can think of…

[iamjoshgreen]

Thanks for trying @msgiblin, yes, I’ve confirmed the input field is type ‘text’ and the database field is type ‘text.’ Did you try saving an external website URL as the input value? That’s what I’m trying to do. The URL is not related to my app/site at all, it’s a user’s personal website. Saving internal URLs saves without any problems.

[msgiblin]

@iamjoshgreen

Did you try saving an external website URL as the input value?

Yes, can confirm that works for me - I just saved a full Amazon URL, here it is in my database:

Can you share a screenshot of the workflow that is creating the new thing?

[iamjoshgreen]

yes, thanks again for helping. Do you see anything wrong with this workflow?

[chris.williamson1996]

Any chance you have any database triggers set?

Go run the flow in debug mode & check logs for the data type

[iamjoshgreen]

got it to work. I removed the ‘only if’ function that searched for another website and for some reason it works now. Weird, oh well.

[msgiblin]

Do you mind expounding / possible screenshots on which part of the process this ‘only-if’ was in? I’m very curious!

[iamjoshgreen]

Ya, the best I can tell is it was just a weird bug I stumbled into. I deleted this only if statement, tested and it worked, then reapplied it and it still works. I’m not sure what was going on.