Notice my script doesn’t include all the fields in my table shown in the image above. Finally, pull over all the data you would like to collect from the original record and set it in the corresponding fields in the new record. Just grab that Script Parameter using the `Get( ScriptParameter )` function and set it into the field we created in step 1. It will require that a script parameter that is the unique `ID` of the record you are trying to duplicate. Once we set the ID of a record in our `ORIGINAL_RECORD_ID` field we will be able to use this relationship to pull the data we want into our new record. It should look something like this when you are done: You’re going to need a new table occurrence as well, in my case I named it `Original Record`. Use the unique id of your table and the field you just created as your keys in this new relationship. Now that we have our field created we need to create a relationship between our duplicate record and the original. Name it something simple like `ORIGINAL_RECORD_ID`. Create this field in the table where you want to create your duplicate records. We are going to need a field so this whole dealio will work. It may seem like a lot of overhead but I think it gives you a lot more control over the process.
I suggest rather then using the `Duplicate Records/Requests` step, use a script, a field and a special relationship. Whenever someone asks me the question *How can I use `Duplicate Records/Requests` to duplicate a found set?*, I typically respond with… **You Don’t.** Seriously, don’t do it unless you are up against a wall and the burninator is coming. We hear he was planning an entire line of exclamation points, and a few OMG!!!’s in his next post. In this instance, they were left in place so that we could publicly ridicule Jesse. Here is how I would approach the task.Įditor’s Note: The use of quadruple question marks is a clear violation of Six Fried Rice editorial guidelines. but a found set? That takes a little bit of thought.
Duplicating in a Record in FileMaker is very easy….
0 kommentar(er)
