cos

The best solution for now as the stored files are only 150kb. I've looped the call through all related records when the order is created and it seems to be working just fine. It's Speedy Gonzales. Thanks for the help.

Could a supercontainer be used here instead of a container? Insert the image from the url into the supercontainer? That would be preferable to easily keep the images external.

Hi Ryan. I did that, but now have a ? in the container. I do need the graphic from the url to be visible at all times. Can I get that to be shown? The graphic is always a png or jpg FYI the source is from a url and not a file.

I have an unstirred Calculation field with this If(not IsEmpty(rtd_order_items_webassistant_URL_side1) ; WAGetURL( rtd_order_items_webassistant_URL_side1 ; "type=container" ); "" ) On a Sales Order layout, the container is in a portal from Line Items. Any interaction with the portal causes a delay with beach ball spin from 1-3 seconds. How can I speed this up?

No problem Lee. And thanks Comment. I added the summary to Line Items and made the script step. Solved.

I have a found set of invoice records using a search for line items matching "paper widgets". Each record has multiple line items but only one line with "paper widgets". "Paper widgets" may have varying quantities on each record. I want to get a summary count of "paper widgets" or the sum total $ across the found set. What script steps could do this? Thanks.

I haven't tested. Not upgraded to v16. I develop and maintain just one FM solution in my company. It is about 10 years old and is kept up to date and feature rich. I'm just doing my homework before upgrading. Soon, I will get into testing. I guess I should call 360works. They are really great people and located only about 20 miles from our business.

This is in the changeling for SC which, if correct, seems to indicate a real and positive move forward same as the other 360works plugins. Version 2.9501 (5/10/2017) Companion plug-in now runs on latest 360Works plug-in platform, with these features: *No longer requires Java installation *Can use plugin functions as script steps with a user-friendly GUI for specifying parameters *Better error reporting in scripts *Compatible with FileMaker Cloud *Better compatibility with FileMaker Server for Perform Script on Server and scheduled scripts *Each plugin runs in a separate process, increasing reliability and stability *Plugins can be reliably unloaded, making it possible to auto-update without restarting FileMaker *Where appropriate, plugin parameters can be selected from pull-down lists and checkboxes *Support for streaming large container data, allowing unlimited amounts of data to be transferred between FileMaker and the plugin without running out of memory. *Compatible with the older plugin API, so you can continue to use your existing scripts and calculations with the new plugins.

Thanks sijmons. I did read this on 360works site today. "The SuperContainer Companion Plugin has been updated with new features for FileMaker 16. It is available as a minor point upgrade, at no additional cost for existing SuperContainer license holders." I hope there are plans to do a full update to SC. It really is so much easier to work with than FM containers. Would be nice to hear some official word posted here. And Bruce, you're correct. I should have mentioned 360works in the title. Didn't think about that because this is the Supercontainer forum.

I didn't see any specific mention of SC in the new platform for FM16. Just that all plugins are compatible. What does this mean? Is this the end of the road for SC?

pinging to bring this up again with a visual. This started happening in the middle of the day and has persisted since then. The extra return is in Filemaker, but is not in the mysql data. Anyone have a clue?

We have a mysql table in FM 15.0.2.220 that seems as though it could be reacting to a FM bug. I don't think this field has been altered recently, but something changed on Oct the 7th, 2016. The field contains 1 to 7 lines of text. There are no extra returns after each line of text. Not in the mysql data. Not in Filemaker. Suddenly on the 7th, the data has an extra return for each line of text. Field format settings look correct. First part of the day it was like this: Line 1 Line 2 Line 3 Line 4 and then it suddenly changed to Line 1 Line 2 Line 3 Line 4 What could cause such a thing and what can we do about it? For now, I guess a calc to strip the returns?

Thanks to all. David's solution is correct. Man, how easy it is to miss the small things.

I have run the Script Debugger multiple times comparing successful page and unsuccessful. It fails at line 2 of the first script. It opens the wrong layout. I can't get past that. But, I did not use the Data Viewer (doh). It is returning unusual data at line 2 which the other layouts are not. Name: rtd_orders::insert_date Value: 8/18/2016 Type: Date That's an old date. Making your suggested changes (which i did, thanks) doesn't matter because it never gets to that script because the first script opens the wrong layout.

This is the new window script that works on all layouts except the Orders List layout: Sales Orders Scripts: Sales Orders Payments: PP - Goto Payments Layout New Window [ Style: Document; Name: "Paypal Payments IPN"; Top: 0; Left: 300; Close: Yes; Minimize: Yes; Maximize: Yes; Zoom Control Area: Yes; Resize: Yes ] Go to Layout [ “Paypal Payments” (paypal_ipn_orders) ] This script trigger runs on layout enter: Sales Orders Scripts: Sales Orders Payments: PP - Open List - Adjust Window Resize to Fit Show ... Allow User Abort [ On ] Show All Records Enter Find Mode [ ] Insert Calculated Result [ paypal_ipn_orders::creation_timestamp; " > " & Get ( CurrentDate ) - 7 ] [ Select ] Perform Find [ ] Sort Records [ Keep records in sorted order; Specified Sort Order: Payments Status::MAP Status; descending paypal_ipn_orders::id; descending ] [ Restore; No dialog ] Scroll Window [ Home ] Adjust Window [ Resize to Fit ] Move/Resize Window [ Current Window; Height: 1100 ] Show/Hide Toolbars [ Hide ] Halt Script The Orders List layout also has a script trigger on layout enter: Online Orders Scripts: OO - Open List - Adjust Window Resize to Fit Show All Records Sort Copy Enter Find Mode [ ] Insert Calculated Result [ rtd_orders::insert_date; " > " & Get ( CurrentDate ) - 6 ] [ Select ] Perform Find [ ] Sort Records [ Keep records in sorted order; Specified Sort Order: rtd_orders::order_id; descending ] [ Restore; No dialog ] Adjust Window [ Resize to Fit ] Move/Resize Window [ Current Window; Height: 1100 ] Show/Hide Toolbars [ Hide ] Scroll Window [ Home ] Halt Script

I have a Payments List View layout that can be opened from any layout using: New Window . . . Go to Layout . . . Except this one other List View layout. It just ends up as a new window of the same layout. New Window . . . Go to Layout . . . will not open any other layout. Driving me nuts. What causes this? FM15 Advanced

All week I have read up on how to set the variable and set the fields in a loop and cannot figure this out. This is my first try at the Let function. It's pretty versatile. It's hard to find examples of how to use it all together in a script. Could you give an example of Set Variable and Set Field using Loop and your rules?

Ah. You are right about the commas. I got mixed up with the previous extraction being one field. The Quantity is a separate field from the rest of the infos in the source and it is joined in the export. Yes, "},{" would give us a carriage return to loop. I can restructure the data a bit that may give a consistent structure by placing Item_ID at the start like this: [{"":"2","unique:2[]":"00254 | Machines | 2.75’’x5.25’’ (1390-LAB 3) vinyl laminated 290 4 to a sheet"},{"":"34","unique:2[]":"00249 | Misc | 2.75’’x1.236’’ (Proudly Built) vinyl laminated 290"},{"":"10","unique:2[]":"00266 | Redbox | 7.9\"x 3.9\" (RBL_outline) vinyl laminated 290"}] Which would always render exactly the same except qty would be 1-4 digits {"":"2","unique:2[]":"00254 {"":"34","unique:2[]":"00249 {"":"10","unique:2[]":"00266

And now for part 2 and final of this extraction. We have another text field that is very similar, but has some distinct differences. The text contains a series of data to be placed in Line Items. Each Line item looks like this: Item_ID Description Quantity The imported data always looks like the following example for 3 line items, but there could be many more. Commas separate each set of line items. There will never be a comma elsewhere. [{"":"2","unique:2[]":"Machines | 00254 | 2.75’’x5.25’’ (1390-LAB 3) vinyl laminated 290 4 to a sheet"},{"":"34","unique:2[]":"Misc | 00249 | 2.75’’x1.236’’ (Proudly Built) vinyl laminated 290"},{"":"10","unique:2[]":"Redbox | 00266 | 7.9\"x 3.9\" (RBL_outline) vinyl laminated 290"}] There first "2" is the Quantity. "00254" is the Item_ID Quantity and Item_ID are all we need to extract for each line item because the description is already in Filemaker with the Item_ID I appreciate any commentary.

Okay. I get it. Done. Works perfectly. You are the champ.

Thanks for this. I understand the Set Fields. I'm a bit confused with the variable. After studying your solution, I think for my understanding, it might be better to replace " | " with simply "|" in the source text. So an actual real world text string would look like this: [{"":"The Test Company|John Doe|1234 Main Street|Beverly Hills|CA|91210"}] In this example "Ship To" is replaced with "" Seems that the source always sends "" for a non-entry in that part. Looking forward to your solution.

Yes. Everything in that line is in the field including curly brackets and quotes. The "Ship To" is the label. I am able to change that to "" so I just placed that text. Constant in every record. Never varies. The "Ship To" label is to be ignored. Don't need that at all. I can also remove the space before and after the vertical bar or change the bar to a dash. It needs to be fairly easy to read on the front end.

Hi. What script steps would extract the data from one text field and place them into separate fields. The field text is this: [{"Ship To":"Company | Full Name | Address | City | State | Zip"}] I need to set field data into corresponding fields: Company, Full Name etc I have control of how the data in the text field is formatted. I used vertical bars, but can change to something else. Thanks

@ MariaAux. I am trying to resolve this also. Wondering if you reached a clear solution. This post http://fmforums.com/forum/topic/91001-remote-vs-local-settings/?hl=supercontainer appears to be a solution.

Current working solution is acceptable for now. Added width and height parameters (which I had forgotten about) and only thing showing now is buttons. I'm good with that. Just hated the scroll bars all over the place. "http://10.0.1.200:8020/SuperContainer/Files/Production03/" & Sales Orders::Invoice ID & "?width=140&height=80&style=noscroll+showdelete"