Ditutup

MaintenanceTRACK - 4 Tables - repost

We are a water filtration company that rents and sells drinking water treatment equipment for commercial accounts. This is an existing FM 12 db. This db tracks our Assets / parts and helps to schedule maintenance for my company using existing multiple tables. Key field structure is sound.

We require a new automated method to add "maintenance tasks" for to the Asset Management table. Our old script was written in FM6 - we need a script written in execute SQL to take advantage of this new powerful feature. We need to Add two scripted buttons:

Single Record ADD Button. Often times we need to add Scheduled actions to the Asset Record shown. So if we have a new Asset Record - we will need to add all of the corresponding Action Items to the part number listed for this asset record. This could be none, one or several action items.

Multiple Records Add Button. This button would add Scheduled actions for a given found set of Assets. In many cases, we have added equipment to various locations in a building. Each Asset record already has the what & where listed - we know need to add all of the service tasks for each Record brought up in a found set. [Right now a simple manual Find will do for all Assets requiring assigned Action Items. Just like the Single Record Add button, instead a loop will be created to query each Asset, determine whether the corresponding Part has Action Items, if so they are then copied and assigned to each Asset Record. This is done for each Asset Record for the found set.

I have multiple Tables in my db - but only 4 that need to be addressed for this project:

TABLES

1) Parts - this lists all Parts and Assemblies

2) Action Items Template Note: Each Part has a corresponding set of recommended "actions" or "tasks" we assign to it.

3.) Asset Management - this tracks all Parts that have been assigned to customers.

4.) Scheduled Actions - Each Asset has a corresponding set of Scheduled Action records assigned to it. For a given Asset we need to assign the corresponding actions based on the Part Number's corresponding Action Template records. By having a tasks list, we are able to assign - the who, what, when, where, why in order to maintain our water filtration systems. Scheduled actions can be organized into reports, data for assignment to field computers etc. Once we have completed maintenance for a customer (we might have several hundred tasks to perform), a tech can use a touch screen computer to mark "complete", time stamp the individual record(s) whereby we can bring this data back into our system and both synch with existing Scheduled Actions, and in addition this allows us to save the performed actions and convert them to Service Records.

Kemahiran: FileMaker, MySQL

Lihat lebih lanjut: why do we need data structure, why data structure, what is record in data structure, tables in data structure, parts list template, maintenance tech, lists data structure, key data structure, filemaker customer service, done right computers, data structure in computer, computers done right, computer data structure, 10 key by touch, tech times, find it tech, data synch, convert my old, Asset management , water management project, automated time table project, sql query loop, mysql simple order management, computer maintenance system, query loop

Tentang Majikan:
( 0 ulasan ) Hyderabad, Saudi Arabia

ID Projek: #4114838

6 pekerja bebas membida secara purata $450 untuk pekerjaan ini

pablotorres

i can do it

$250 USD dalam 21 hari
(37 Ulasan)
4.8
seekdeveloper

Hi, Kindly Check PMB

$750 USD dalam 10 hari
(2 Ulasan)
4.6
MattyM01

Hi, I am an experienced developer in FileMaker Pro, and specialize in creating custom database for a variety of uses; everything from CRM, stock and inventory, accounting, etc. I am definitely capable of completi Lagi

$500 USD dalam 7 hari
(3 Ulasan)
4.3
timlit

Hello, Sir! I'm good with both FMP and SQL.

$350 USD dalam 10 hari
(2 Ulasan)
1.6
ingila

I can do this for you. Please check pmb.

$250 USD dalam 3 hari
(0 Ulasan)
0.0
kjtl

The quote is to 1. Create methods to automatically create tasks to maintain your equipment. 2. Create a method to download the task information to mobile ios devices utilising filemaker go. 3. Create a method to Lagi

$600 USD dalam 7 hari
(0 Ulasan)
0.0
johndwalton2012

Greetings, I have seen your project, and, although I am not interested in it, I am interested in making sure that you do not get taken in by anybody else. I am a FileMaker developer with 13 years of experience Lagi

$250 USD dalam 0 hari
(0 Ulasan)
0.0