AnsweredAssumed Answered

RecordID, CurrentRecord

Question asked by SkipperID on Dec 11, 2014
Latest reply on Dec 13, 2014 by philmodjunk

Title

RecordID, CurrentRecord

Post

Hello Filemakers!

I've created a button on most layouts that goes to a table and creates a "Help Ticket" for some of my users. 
Basically, it means "I was trying to enter this data and I have a question on this record or layout" 

The button Script does:

SetVariable[$TroubleTable; Value:Get(LayoutTableName)]
SetVariable[$TroubleLayout; Value:Get(LayoutName)]
SetVariable[$TroubleRecord; Value:Get(RecordID)]

then, (summarized) Create a New Window, Go to the TroubleTicket Layout, Create New Record and:

Set Field [TROUBLE::CurrentTable; $TroubleTable]
Set Field [TROUBLE::CurrentLayout; $TroubleLayout]
Set Field [TROUBLE::CurrentRecord; $TroubleRecord]

I don't think Get(RecordID) is the right function to be using. Or Get(CurrentRecord)
I want it to return the value in the ID field that I have created (TableName:ID), But the Value in the CurrentRecord field is a number instead of the text+serialnumber in the field
 
Every table has an ID field, (auto generated, serial #) am I cheating by asking this script to use the "ID" no matter what the table is without setting the table name and field? Somehow I think I need to be more specific about the field. 
 
Any advice to get that ID from a field in any table? 
Thanks!

FM13

 

 

Outcomes