I am looking for a Claris FileMaker Pro developer.
I do not want to assign a larger project without some personal history with the person i will be working with.
This request is not for the whole project, just a for a function and if you really know Filemaker code this should be really easy task.
The initial task and your bid applies to:
I have 2 tables "Orders" and "Inventory".
I want add a column "Sold Past 30 Days" to "Inventory" that get the sales history from the past 30 days. All products in "Inventory" have a unique ID that can match from "Orders". "Orders" table include all neccecery data like "OrderDate", "QtySold". I want the sum of the "QtySold" past 30 days.
Matching ID:
Lager::Property EAN
Order::identifier
Needed:
Order::created at
Order::quantity
Result should be showed in:
Lager::SoldQty30Days
Something like SQL-ish(i am no coder):
Lager::SoldQty30Days =
SELECT SUM (Order::quantity)
FROM Order
JOIN Lager
ON Order::identifier = Lager::Property EAN
WHERE Lager::Property EAN = Order::identifier AND Order::created <= (30daysMax)
Filemaker project containing data will be provided.
Hello Sir,
I am an experienced Filemaker developer who helped hundreds of companies with their in-house Filemaker based solutions.
I developed inventory applications, production planning and scheduling applications, sales applications..etc
By looking at the required job, I say it will take 5 mins and without using ExecuteSQL (which by the way is not recommended inside fields as it is a well known performance issue with large datasets)
Thank you for reading my bid
have a nice day!
$10 USD ndani ya siku 1
5.0 (3 hakiki)
4.2
4.2
5 wafanyakazi huru wana zabuni kwa wastani $19 USD kwa kazi hii
Hello,
I am a full time FileMaker developer, I mainly develop custom management solutions for companies and individuals, with 9 years experience, specializing in FileMaker systems and data management.
Please check my portfolio & Reviews.
I would be glad to help.