Editing multiple records (checkboxes)

[jangel]

I'm sure there's a simple answer to this, but...

Is there a way to edit multiple fields using checkboxes? The format file contains a form showing multiple records- each with a checkbox displayed for the field 'Remove'. I want the user to be able to check multiple records, subit the form, , and have the records edited. I have tried doing this 2 different ways, but I must be doing something wrong.

Thanks in advance!

[Kittrick]

quote:

---

Originally posted by J Angel:

I'm sure there's a simple answer to this, but...

Is there a way to edit multiple fields using checkboxes? The format file contains a form showing multiple records- each with a checkbox displayed for the field 'Remove'. I want the user to be able to check multiple records, subit the form, , and have the records edited. I have tried doing this 2 different ways, but I must be doing something wrong.

Thanks in advance!

---

Hi J,

I am working on a real-time sign in program and had to do what you are talking about but with only one record at a time. I'm pretty sure that if you set up both of your pages, the one you are talking about that has the "remove" and seperate checkboxes, and a page that you get to after declaring that you only want to see the [FMP-currentrecID]'s of those selected by the checkboxes.

You will have to create a new field to validate this and the calculation would be like If(whateverfieldhasthecheckboxes="",0,1) . Then you put the 1 (if the checkbox is not blank) in the link to the format page where you have set up for editing the multiple records and have the page have a

[FMP-If:Field:whateveryounamedthenewvalidationfield .neq.][whateveryounamedthenewvalidationfield]

then your <input type="text" VALUE="[FMP-field:whateverfield]">

[/FMP-If]

I think this may work, or a variation of this may work. I hope I helped put you in the right direction.

[Vaughan]

The only way I know to edit multiple records - in FMP and over the web -- is with a script. Perform a find to isolate the desired records, then Replace the field values or use a loop to work through each record individually.

I'll leave it to others to speak of the evils of running scripts over the web.

[Keith M. Davie]

If you want to see all the joy of running a looping script you will find all the necessary code and db structure as a (if I recall correctly) four-part "...Entertainment..." on the cdml forum. Spend a little time to learn a lot.