Software Consulting Development   Contact   Home

                      



Ebay Interface  Development
Automate listing and reporting of your inventory / goods for sale.

Web Site Search Optimization
Automated Sitelist Generation & Update
Google requires a sitelist to be generated for your site in order to get the best rankings.
More

Linux Development
Applications and Solutions for:
Printing Local, Remote & Cloud.
Mobile Data
Remote Control
Automating Processes

Filemaker Developer
Relational Databases
Turnkey stand alone applications
that run on Windows MAC IOS and can be accessed over the internet.
Interfacing to existing databases and online services like Google Docs.
Screen Shots.

Custom Flat File Systems
Filemaker code for Generating searchable flat file systems for the Internet.
Ideal for Catalogs, Equipment Listings, Data Lookup, Status Reports
Example
Google forms that modify themselves to your customer or users answers.

Mobile Data
Full two way data over the Internet.
Scan Print Chat Voice
Voip phone.
Communicate with your office, residence, boat, plane,
More...

Custom Data sets


Satellite Phone Systems
Future Developments
Google Forms for Customers
Filemaker Pull data From Google Forms
This is superior to using web direct.
Fully Scalable.


Pull sheet into container
Export File
xlsx, pdf, tsv, csv, ods, and zip (a folder with the sheet as html)

Matt,
I use a google sheet that gets updated by Mailchimp form on a web site. I wrote a database that accesses the google sheet and imports it into a filemaker database using an insert from url call. This way a filemaker db user doesn't have to interact with google at all.
I import the file into a single field - and process one line at a time , replacing the Char(44) with Return. Just use getValue to move the info into the correct fields, then go to next line.

In my case I just delete the database of all names and import all the new data, then process for possible duplicates. You could also import to a secondary table then compare with working table of addresses or Just compare field by field in a record as you import. Any case this works well and keeps the user out of google sheets. In google sheets use Get shareable link. Put this in the the Insert from Url script - Looks soomething like this - "https://docs.google.com/spreadsheets/d/1lmjTMssUVojtfbQp64-h2WaVhPXhfEll...

Video

Create fields in order that they will be lused.


Google Sheets