FileMaker Pro simple function

Đã hoàn thành Đã đăng vào 1 năm trước Thanh toán khi bàn giao
Đã hoàn thành Thanh toán khi bàn giao

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

ID dự án: #33861263

Về dự án

5 đề xuất Dự án từ xa 1 năm trước đang mở

Được trao cho:

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, Thêm

$10 USD trong 1 ngày
(3 Đánh Giá)
4.2

5 freelancer chào giá trung bình$19 cho công việc này

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 p Thêm

$30 USD trong 7 ngày
(21 Nhận xét)
6.1
stefanoturchet

Hi, I’m a FileMaker developer with a long experience in FileMaker. . I can make the function you request in a easy way

$15 USD trong 2 ngày
(5 Nhận xét)
4.3
alexstuart977

Optimal solution 10+ years of experience Knowledge on cwp integration via php, angular. Stripe integration experience

$30 USD trong 7 ngày
(1 Nhận xét)
0.0