Trying not to use AppleScript

[dynedwebmaster]

So here's what I'm doing. I have 10 fields, numbered s1, s2,...s10

On a web page, I want the user to submit a number

the database recognize the number and pulls the corresponding field into another field

manipulates the new field and returns the manipulations of the new field to the user.

I don't want to do this in AppleScript because it ruins the cross platform aspect to it all.

Here's how I do it in AppleScript. Keep in mind field "q" is the submitted number from the user, and field t60r is the common field that the value will be put into.

set currec to current record

set activeQ to cell "q" of currec as string

set activeS to "s" & activeQ

set thecell to cell activeS of currec as string

set cell "t60r" of currec to thecell

[CaelC]

I'm not sure I'm understanding fully since I don't know AppleScript ... Can you just use another set of fields like S1calc that calculates/manipulates the data from S1 only if data is present and then return the calculated result?

Cael.

[dynedwebmaster]

Well the problem is, I want to have 1 format web page and 1 field that the web page reads from. The problem is we have 10 questions. I don't want to have 10 different web pages that return each of the calculated fields.

I can't find anyway to pass variables in FileMaker, so how do I say:

1.This is the question that the user is working on

2.Take that question number

3.Compare the answer they've submitted to the correct answer

4.Return whether or not the question is correct or not.