Method:Classic General Q&A

Re: Loop string of comma separated values?

wombatmaster — Thu, 20 Jun 2019 18:11:22 GMT

That being the case, I would suggest creating a reporting module on your site and iframing it into Method using a Web Page Window object. If needed, you can add custom CSS by dropping a label-type field into a hidden section, creating a custom table containing long text fields you can use for your CSS, then applying to the hidden label on page load using the Advanced button to the right of the screen name in the editor.

This is all assuming you're using the Classic version. Have not done much with New yet personally. Lacking the ability to utilize custom SQL lookups, is useless to us.

Re: Loop string of comma separated values?

Tim Annis — Wed, 19 Jun 2019 14:33:02 GMT

Are you saying that there is a way to write in PHP, or some other languate on the Method platform? Because my problem is taking a multi-record JSON response (with an unknown number of records) from a web service, and looping through it to load a custom Method table. Obviously calling another external web service isn't going to help with this.

Re: Loop string of comma separated values?

wombatmaster — Mon, 17 Jun 2019 20:00:03 GMT

The only way to effectively accomplish this within Method without losing your hair in the process is to develop your own API. Then, push the request using a web service call, chop/stir-fry/bake/garnish, what have you, using an actual programming language with real flexibility, and serve back to Method in whatever form is desired or requested.

Re: Loop string of comma separated values?

Tim Annis — Fri, 14 Jun 2019 14:14:40 GMT

How do you do the "Rinse and repeat" part? There doesn't seem to be any loop that isn't tied to either a grid or a table. Not even so much as a goto function.

Re: Loop string of comma separated values?

furrywombat — Sat, 04 Apr 2015 23:19:06 GMT

Awesome, thanks Justin.

Re: Loop string of comma separated values?

Method_Justin — Mon, 30 Mar 2015 18:12:30 GMT

FW,

You would have to do something like this:

Character Function - Find Character to find the location of the first comma
Subtract value from step 1 by 1
Substring the first value by using Character Function - Get Left with the value from step 2
Do something with the value
Substring the remainder of the string by adding 2 to the value from step 3 and using Character Function - Get Right with that value

You should now be left with a list of values that does not contain the first value from the initial list

Rinse and repeat

Hope this helps.

- Justin

Re: Loop string of comma separated values?

furrywombat — Mon, 30 Mar 2015 15:47:02 GMT

Justin,

I'm working on a concept where we would call a web service (ours) from Method. The web service would return a comma-separated list of values that would be specific to, say, for example, the Invoice table. I would like the returned value to be parsed as an array and then loop through each individual value... something like this:

Call web service https://www.domain.com/webservice.whatever?var1=x,var2=y and assign return value to action result webServiceResponse

Web service response = 1,2,3

Explode webServiceResponse to aray.

foreach (webServiceResponse as webServiceEach) {

do something with webServiceEach

}

Make sense?

Re: Loop string of comma separated values?

Method_Justin — Mon, 30 Mar 2015 15:27:06 GMT

Hi furrywombat,

This may or may not be possible depending on what you're trying to do. Could I get a bit more info on your use case?

Let me know.

- Justin

Loop string of comma separated values?

furrywombat — Sun, 29 Mar 2015 23:11:40 GMT

I was wondering if there was a way to loop through a string of comma separated values, like a foreach statement, assigning the iteration value to an action result?