Re: Help choosing a field from a script


<squeed2000@xxxxxxxxx> schreef in bericht
news:1185046432.785769.103590@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I get what you are saying here, and this is what I tried, but it seems
that in FMP7 the "Set Field" command can not be based off of a
calculation.

Also, is there a way to have FMP choose the fields itself, or do I
have to manually code them.

-S



Well with only three fields it is only three if in the script,

But it is easy enough to work around. at least in V8.5, I don't remember if
V7 already had objectnames.

Apply an objectname to each field. You can use the fieldname as object name.
Then use the goto object scriptstep (this can be calculated)
the next script is Set Field without (!!!) specifying the field name. In
this way it will use the currecnt active field.

Keep Well, Ursus


.

Relevant Pages

  • Re: Why does database not open to the last record visited
    ... I ended up setting up a FMP script that stamps the serial number into ... the global field by calculation. ... the solution to all my databases. ...
    (comp.databases.filemaker)
  • Re: Find in a date range
    ... I want to create a script that will select all records in the past ... Due to a bug in FileMaker, you may need to swap Set Field to ... Assuming you mean a calendar month the calculation part of the Set ... Field above has to work out the current month and subtract 1. ...
    (comp.databases.filemaker)
  • set the name of a variable by calculation
    ... FMP 10 Advanced: in the script step "set variable", ... define the variable name is to hardcode it. ... set field by name? ...
    (comp.databases.filemaker)
  • Re: Set Field doesnt accept parameters
    ... And, by the way, Set Field does not work at all. ... parameter, whether in an If loop, or subscript or calculation. ... so you can use one script to be run from six different buttons. ... > getin the script to branch off to different layouts, ...
    (comp.databases.filemaker)
  • go to a record
    ... I am using FMP 10 on Windows XP. ... I see "GO TO RECORD" as a script possibility but the only choice that seems to work is a Calculation but you have to enter something that comes back as a Number. ...
    (comp.databases.filemaker)