Forums

here is the situation. I have a form set up for an inventory system. this inventory system shows both used and new product. I have set each up as a separate form and table for ease of use. However, in the used product inventory the final price, retail etc. has to be approved by the company executive. now I have figured out how to get the icon to show in the toolbar, but I don't know how to set it up so on clicking that icon, it approves the checked record. similar process to the delete record command, however this will need to update the table info so that the approved changes to yes, instead of under review, and it allows the input of the executive authorizing the approval with a dropdown list of those authorized to do it. I written a separate PHP file but I have have no idea how to make it pull the specific record to be approved.

Any help on this? if you need more clarification please let me know.

Thanks

Hi efwis,

I'm afraid that this is a piece of custom coding well beyond anything that ChronoForms offers.

I'd be inclined to move this code to the front-end, separated from any Form Management activities.

I guess that you'd need to add fields to the table to record the status of the item (and probably to record who approved it and when).

Then a new form with limited access could pull up a list of items waiting approval. In each of these you could include a checkbox linked to the record ID, or some clever JavaScript, or a link back to a php page passing GET variables.

I hope this helps a little.

Bob

thanks, I will see what I can do. I hope this could turned into a feature sometime down the line. I know this would help for those that make custom shopping carts to be able to update their inventory or certain sales.