I cannot fathom how to price my Products table from a daily fixed pricing I get from web site or Excel, using excel import or set up web calculation fields. Any ideas?
If you have a table that contains your daily pricing, the ID of the product and the date, you can link to that and pul your pricing.
Agnes B. Riley
FileMaker 10 and 11 Certified Developer
ZeroBlue Technology Solutions
where your data goes to work
Member, FileMaker Business Alliance
Member, FileMaker Technical Network
FileMaker Advanced 11.3 on Mac OS X 10.6.8
"Imagination is more important than knowledge..."
Unfortunately, the pricing is not determined by me. So I need to GET the daily price from an Excel file that dynamically WILL fetch it from the web, or find a way to get it within an external source from FMP11
Well, you cannot connect to an Excel file. You can set up an import from it, though, every day.
The other solution is to connect to the source itself: the website. Do they offer an API?
Retrieving data ...