User input

[EKoster]

I want to make a script in which the input of a user is requested in a dialog. The input is to be a typed value (not a check box).

How can I do this? The data isn't to be stored on the open record, and I mustn't leave the open record.

[mr_vodka]

If I understand correctly, then create a global field and then use a custom dialog.

[EKoster]

I tried this now. Unfortunatly I have a same issue as other things I try that information can't be entered.

I placed this field in the data table, the field was cTNT_Input, calculation, global. I can't make text fields for some reason. The tables are with a internet ODBC connection.

[mr_vodka]

The tables are with a internet ODBC connection.

That was an critical fact to leave out in your original post.

You can not create FileMaker data entry fields through an ESS connection. If you are going to create a field then do it in the external source table. You can only create calculation and summary fields within FM's ESS.

I do not know what you are trying to achieve here. However, you can create a global field in a FileMaker table and access it anytime.

[EKoster]

Okay. I change my databaseconnection to the local mysql database.

Then I made a temp table with a field TracknTrace. I made a script that pops a input box to fill the field. That works.

Now I want it immediatly in the database online so I added the sql rule:

"UPDATE [table] SET trackntrace = '" & temp::TracknTrace & "' WHERE [col]='" & [table_alias]::[col] & "'"

The where field is a field from the mysql database. If i look in the database when the rule is finished the input is NULL. if I replace "UPDATE jcs_vm_orders SET trackntrace = '" & temp::TracknTrace & "' WHERE order_id='" & Data::order_id & "'" with any value it works....

[EKoster]

I solved this issue it now works. Messed with the temp table till it worked