Auto create record in another file

[Dana G]

Could anyone tell me how or if it is possible to...

automatically create a record (in another table) when a specific checkbox is checked? :qwery:

[-Queue-]

Does the value list for the checkbox consist of a single value or multiple ones?

What is the purpose of creating a new record in the other table?

[Dana G]

Correction: I want the record created in another TABLE within the same file.

The set contains multiple values (8 to be exact).

Basically the RFI Layout is a question from a Contractor that we (the architect) answers. When that RFI answer is telling the Contractor to change something on the building, a record in the MC Layout needs to be created that will tell the architect what the issue was and what needs to change on the blueprints.

When a record in the "RFI layout" (rfi_table) is answered and "SS" value (checkbox) is selected, it is a signal that the answer is a change to the building and that the architect needs to change the blueprints.

Instead of making someone go into both layouts and document the information, I wanted to make it automatic.

I need for a record to automatically be created in the "MC layout" (mc_table) when the "SS" checkbox is selected on an RFI record. When the record is automatically created in the "MC layout" it needs to have copied data from the RFI record and pasted it into the newly created MC record.

Does that help?

[-Queue-]

Correction: I want the record created in another TABLE within the same file.

Yes, that's what I asked about.

If the values for SS are constant, you can create a button over each checkbox which is attached to a script to create the new record in the MC table and pass it the appropriate SS value as a script parameter.

[Dana G]

Sorry :, doing too many things at once!

So when I make the button, obviously I make it look like a checkbox. How does it know to also check the box? Is that something I have to put in the script when the button is clicked?

[-Queue-]

Each button can be transparent, sized to match a checkbox, and placed directly over the appropriate checkbox value. If more than one value may be selected, the script will look a bit differently than if only one selection is allowed. Either way, the script will use the Set Field step with Get(ScriptParameter) in its calculation.

So, which type do you need?

[Dana G]

They will be able to click multiple values.