FileMaker Pro simple function

$10-30 USD

Imekamilika

Imechapishwa

almost 2 years ago

$10-30 USD

Kulipwa wakati wa kufikishwa

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.

FileMaker

MySQL

Kitambulisho cha mradi: 33861263

Kuhusu mradi

5 mapendekezo

Mradi wa mbali

Inatumika 2 yrs ago

Unatafuta kupata pesa?

Barua pepe

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa

Pata malipo kwa kazi yako

Eleza pendekezo lako

Ni bure kujiandikisha na kutoa zabuni kwa kazi

Imetolewa kwa:

@fmriadh

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

5 wafanyakazi huru wana zabuni kwa wastani $19 USD kwa kazi hii

@MooRabie

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.

$30 USD ndani ya siku 7