Often, you want to copy a record and change one thing, like a date, or make some other minor modification.
numero = 138<a href="youreditpage.dna?edit=t&ID=[ID]">EDIT</a> | <a href="youreditpage.dna?edit=t&ID=[ID]&clone=t">COPY</a>FORM element
[hideif [clone]=t] <input type=hidden name=ID value=[ID]>[/hideif]WRITE to the DB
[replace db=yourdatabase.db&eqIDdatarq=[ID]&append=T&autonumber=ID]....[/replace]NOTES
Make sure your editing form contains all the fields; often a new form has additional fixed fields that are set only on a new record. So you may have to add these in hidden form elements.
If you want to make sure a particular field is replaced with new info, do something like:<input type=text name=mtgdate value="[hideif [clone]=t][mtgdate][/hideif]">You can also put this at the top of the form:[showif [clone]=t]This form will create a New Copy of an existing record[/showif] to reassure yourself that you aren't editing away an existing record.You can change the text on the submit button to Clone in the same way with showif/hideif.
I have come up with a very simple technique. Alongside the link to EDIT a record, I make a link to CLONE a record, adding clone=t to the editing link. Then in the editing code, there are only 2 simple alterations. In the form itself, use [hideif [clone]=t] to hide the hidden variable for the record ID, and in the replace context, add &append=t&autonumber=ID (or whatever your record ID field is called). When you search for the record to populate your field, it finds [ID]. But when you submit the form, this variable is not sent and only the raw code, [ID] displays for the replace, so the record is not found. Hence, a new record is created with a new ID.<a href="youreditpage.dna?edit=t&ID=[ID]">EDIT</a> | <a href="youreditpage.dna?edit=t&ID=[ID]&clone=t">COPY</a>
[hideif [clone]=t] <input type=hidden name=ID value=[ID]>[/hideif]
[replace db=yourdatabase.db&eqIDdatarq=[ID]&append=T&autonumber=ID]....[/replace]
Make sure your editing form contains all the fields; often a new form has additional fixed fields that are set only on a new record. So you may have to add these in hidden form elements.
If you want to make sure a particular field is replaced with new info, do something like:
<input type=text name=mtgdate value="[hideif [clone]=t][mtgdate][/hideif]">
You can also put this at the top of the form:
[showif [clone]=t]This form will create a New Copy of an existing record[/showif]
to reassure yourself that you aren't editing away an existing record.
You can change the text on the submit button to Clone in the same way with showif/hideif.
DOWNLOAD WEBDNA NOW!
WebDNA applications...
Technical Change HistoryThis Technical Change History provides a reverse chronological list of WebDNA changes...
Tips and TricksA list of user-submitted tips ...
F.A.QA compilation of some user's questions...
WebDNA LibrariesA list of available libraries for WebDNA...
WebDNA ModulesA list of the currently available modules...
This will show or hide stuff according to the IP...
How to setup CODA to work with WebDNA?This page will show graphically how to setup CODA as a WebDNA partner :-)...
Find duplicate recordsFind duplicate records and do something with them...
WebDNA interaction with ImageMagickHow to pass variables to ImageMagick using a [shell] context?...
Extracting the first sentence out of a block of textI need to extract the first sentence out of a block of text...
WebDNA interaction with zipI have a project where I'm allowing several people to upload images...