Help Needed with Webviewer calculation

[deejhan9]

I will be grateful if someone can help me as I have wasted last two days trying to solve this problem.

 

I am trying to use web viewer in filemaker pro 11 to get the results but its doesn't seem to work or I am missing something.

 

what I am trying to let web viewer find items online for me from there barcode. I have a database of products with barcode and I would like filemaker to go on google, amazon to check if the product exist and show the description.

 

I am able to display the product if I manually add the barcode or item name in the script. But I am unable to link to my barcode field so that It pick up the field for that particular record. I tried to use Get Parameter script but these is not luck and now I decided to get some help from filemaker community.

 

So please help me.

 

I searched on the google and read that Web Viewer examples.fp7 have similar examples but I am unable to get that database online or neither on Filemaker.com website.

 

So your help will me much appreciated.

 

Regards,

Dee

[AHunter3]

Please type (or paste) here the complete URL to a google search results page for ONE of your products, followed by a note explaining what part of the URL is your product.

 

I would also need to know what actual information is encoded in your barcode field: is it a Product ID field, with a table of product names and product IDs existing somewhere in your database? Is it the product name itself? Etc.

[deejhan9]

Thanks for your prompt reply. Please see below what I am intending to do.

 

Step 1: I scan a product through barcode script and the barcode gets stored in text field table called barcode. (This is working for me)

 

Table setting for Barcode is - Name - Barcode - Field Type - Text - Options/Comments - Indexed.

 

Now what the next step should be for web viewer to check that barcode number. Currently I am using amazon to check products. This is the url I am using -

 

http://www.amazon.co.uk/s/ref=nb_sb_noss_1?url=search-alias%3Daps&field-keywords='>http://www.amazon.co.uk/s/ref=nb_sb_noss_1?url=search-alias%3Daps&field-keywords=one+shot&x=0&y=0

 

In the above example I am searching for a product called One Shot. The url also works with below example as well

 

http://www.amazon.co.uk/s/ref=nb_sb_noss_1?url=search-alias%3Daps&field-keywords=one+shot

What I would like the script to do is actually fill the last parameter after keywords=

from the barcode field.

 

I have given you example with product name. We can do the same with Barcode number as well.

 

http://www.amazon.co.uk/s/ref=nb_sb_noss?url=search-alias%3Daps&field-keywords=5010924724079&x=0&y=0'>http://www.amazon.co.uk/s/ref=nb_sb_noss?url=search-alias%3Daps&field-keywords=5010924724079&x=0&y=0

 

http://www.amazon.co.uk/s/ref=nb_sb_noss?url=search-alias%3Daps&field-keywords=5010924724079

 

Hope this will help.

 

Thank you for your help and support.

 

Regards,

Dee

[AHunter3]

Since you say it works with the barcode number itself, the easiest thing to do would be to define your webviewer calculation as

[noparse]

"http://www.amazon.co.uk/s/ref=nb_sb_noss?url=search-alias%3Daps&field-keywords=" & YourTable::Barcode & "&x=0&y=0"

[/noparse]

[deejhan9]

Thank you for your response. I tried the above method and it worked perfectly well. If I may ask you another advice.

 

Is it better to use images as reference or shall I put it in containers. The reason I asked is that 1st - If I put images in container, it takes so much space and 2nd I want to use same images for two different databases.

 

So the advice I require is how can I reference the images from website. All the images are on my web server as they are also used for website images. I want to reference them thru website. For e.g. http://www.example.com/images

 

So please give me your thoughts on this as how can I achieve this. Currently I am importing pictures into container field.

 

Have a lovely day.

 

Regards,

Dee

[AHunter3]

First question: who will be using your database, and HOW? Will it be used by people using FileMaker Pro, or/also by people using a web browser? And of those using FileMaker Pro, will they be people working at the same company that you do, at your same location, and they will be on your same internal network and can access your same file servers?

 

Second question: you say the images are on YOUR web server. Can that web server's files and folders be accessed directly by mounting the server's drive on folks' Desktop? (or, if you have Windows users, by browsing "Network Neighborhood")? If so, that's how you reference the images: you insert them as a reference not using their http web path address but by inserting them as images (stored as references) from their location on a mounted server volume.

 

Note that if you are a cross platform environment you will need another layer, a calculation field, to handle platform variations. If not, no reason to give you details you don't need.

[deejhan9]

Thanks for the reply. Well I will be using the database myself and the others are only viewing the database but no input will be added from other staff as this database will be used as an reference. The database I have designed is for online commerce company and I will be the only person who will be updating the records and amending them as required.

 

Currently I use Filemaker pro on my iPhone and record the product details from our warehouse and later store that database to the mac. As I am building up the inventory from two different locations, I will be updating the products on different databases depends on items on these locations and sometimes they will have similar items hence wanted to reference the images.

 

The images are on the web server. Basically on the hosting server of the site where the commerce site is hosted and I am intending to use the images from that server thru direct url link as a reference. If this cannot be done then may be we can use it on local machine i.e. on my mac and use it there as a reference.

 

I am not using cross platform. Only using Mac, iPhone and iPad to work on this database.