Search found 11 matches

by smckinney
Tue Apr 15, 2025 3:10 pm
Forum: Switch
Topic: Undefined is not a function
Replies: 2
Views: 32648

Re: Undefined is not a function

Oh my gosh, you are a lifesaver thank you!! This was killing me! Also thank you for the link, I've been looking for something like this!!
by smckinney
Mon Apr 14, 2025 11:20 pm
Forum: Switch
Topic: Undefined is not a function
Replies: 2
Views: 32648

Undefined is not a function

Hello everyone, I'm having an issue with my script. I'm honestly just running test scripts but regardless if I'm putting in one that I thought would work or the actual script I want to be apart of the flow, I'm still running into the same error: "undefined is not a function." I've also tri...
by smckinney
Fri Jul 15, 2022 5:07 pm
Forum: Appstore
Topic: Google Sheets Formulas
Replies: 1
Views: 14656

Google Sheets Formulas

I have a few rather complex formulas I would like to use with google sheets connector app but I can't quite seem to get the <<rowNumber>> to work in this particular formula. I have used <<rowNumber>> in other more simple formulas but there's something about this one. Expense Code::=INDEX('MMFulfillm...
by smckinney
Tue May 31, 2022 5:43 pm
Forum: Applications
Topic: Database log
Replies: 3
Views: 13878

Re: Database log

Thank you!

That worked exactly as I needed it to. This opens so many doors for us with GSC
by smckinney
Wed May 25, 2022 8:46 pm
Forum: Applications
Topic: Database log
Replies: 3
Views: 13878

Database log

I have linked my database to switch and am able to pull data directly from our database into a log csv file. I would like to be able to upload the log into google sheets for formula functionality. If I upload my "log" as an excel file, I am able to retain all of my columns but without the ...
by smckinney
Thu Apr 28, 2022 3:39 pm
Forum: Switch
Topic: export data from database
Replies: 4
Views: 6615

Re: export data from database

That's exactly what I was missing!

Thank you so much!!!! :D
by smckinney
Wed Apr 27, 2022 7:56 pm
Forum: Switch
Topic: export data from database
Replies: 4
Views: 6615

Re: export data from database

That's closer.. but it only returns 3 records max. I need all of the records from a selection returned
by smckinney
Mon Mar 28, 2022 8:11 pm
Forum: Switch
Topic: export data from database
Replies: 4
Views: 6615

export data from database

what are my options to use switch for exporting data from my database as an xlsx or csv file?
by smckinney
Fri Mar 18, 2022 7:05 pm
Forum: Online proofing (PDF Review Module)
Topic: external email capture
Replies: 2
Views: 17552

Re: external email capture

I Just want to tag onto this thread to say that I too am looking for a way to show who approved the proofs. There is the pdf review module reporter app that lets us know who "reviewed" the job but knowing who approved it would be super beneficial in many cases. Hopefully this will let enfo...
by smckinney
Thu Aug 26, 2021 4:40 pm
Forum: LEGACY scripting
Topic: read and write excel file
Replies: 1
Views: 12065

read and write excel file

I have an excel file that I need to read from to write to a new excel file which would be output in switch. The script I have works and does exactly what I need it to when I run it in Visual Studio Code. When I bring it into Switch Scripter I keep getting this error: Cannot find module '/Users/switc...
by smckinney
Mon May 17, 2021 5:42 pm
Forum: Applications
Topic: Identify InDesign Package folder
Replies: 3
Views: 8402

Re: Identify InDesign Package folder

you should be able to change the property of the connector under "include these jobs" to define which files should pass to InDesign.

you can chose based on file type, pattern, expression, condition with variable, or by script expression.
Capture.PNG
Capture.PNG (50.75 KiB) Viewed 8395 times