Jump to content

Welcome the ORIGINAL FileMaker Community

Take a moment to join us, no noise, all FileMaker...We Promise

Recommended Posts

sjump

Hello Guys,

i’m a novice in the filemaker world and as every new challenge, i don’t miss to get stuck in some problem, called “script”.

 

Let me explain:

 

I have got 5 tables called :

 

1. Table “Company”

2. Table “Customers”

3. Table “Terapy”

4. Table “Trap”

5. Table “Report”

 

They are related as follow:

 

1. Table “Company”:: Id company…… X ….. “Table “Customers”:: id customer

 

2. Table “Customers”:: Id customers…… = ….. “Table “Terapy”:: id customer

Table “Terapy”:: Id terapy………….… =. ….. “Table “Terapy”:: id terapy

 

3. Table “Terapy”:: Id trap…… = ….. “Table “trap”:: id trap

 

4. Table “Terapy”:: Id report…… = ….. “Table “Report”:: id raport

 

 

I have developed already the Desktop interface, with tabs, buttons and checkbox, and everything seams to going good, i can add data into the table “customers” and i am adding data in the related tables using Portals, so like this the database is populating and working in the desktop side.

 

I did the same with the preparation of the “IPAD” interface, i ve developed one main layout called "“Customer | ipad ”, where i can add customer data (as name-surname etc..)and add two buttons, which links to the “report layout | ipad ” and “trap layout | ipad”

 

……… The troubles start here when i pushed these buttons……

 

What i would like to do when i push the buttons is:

 

1. Check if any record exist already in the “report” or “trap” table a record, if is not then i would like to create it, relating the Customer id, trap id and terapy id.

 

2. When i am in the ipad layout “trap layout | ipad” and ”report layout | ipad” , with the help of a button called “add new record ” , add a new record relating the Customer name and surname or customer id.

 

Actually the script to go from the “Customer layout | ipad” to the “Trap layout | ipad” look like this:

 

Script name : “go to trap | ipad”

 

Set Variable [$$ Current_customer; Value: Customers::idcustomers]

Set Field [Trap:: Data;””]

Go to related Record [show only related records; from table: “Trap”; using layout “trap layout | ipad”(Trap)]

if[Get(LastError)=0]

Sort Records [Restore;No dialog]

Halt Script

End If

Show Custom Dialog [“No Trap’s records, add new?”]

if[Get(LastMessageChoice)=1]

Halt Script

End if

Go to layout [“trap layout | Ipad”(Trap)]

New Record/Request

 

——————————————————————————————————————

 

Script to add a new record in the ”trap layout | ipad” using filemaker go:

 

Script name: "Trap new record | ipad"

Go to Related Record [From table: “trap”; Using layout: “trap layout | ipad” (Trap)]

Go to Field [Terapy::id terapy]

New Record/Request

Insert Current Data [select; Trap::data]

 

What do you think can you please help me in solve my lack of knowledge? I really appreciate any thoughts

Thank you guys

Edited by sjump

Share this post


Link to post
Share on other sites
This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.




×
×
  • Create New...

Important Information

Terms of Use