Search found 9 matches

by smckinney
Fri Jul 15, 2022 5:07 pm
Forum: Appstore
Topic: Google Sheets Formulas
Replies: 1
Views: 4862

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: 5867

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: 5867

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: 2965

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: 2965

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: 2965

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: 7356

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: 8994

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: 5834

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 5827 times