Jump to content

Editing multiple records (checkboxes)


jangel
 Share

This topic is 7217 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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!

Link to comment
Share on other sites

  • 4 weeks later...

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.

Link to comment
Share on other sites

  • 2 weeks later...

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. wink.gif" border="0

Link to comment
Share on other sites

This topic is 7217 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.