Record Moderation

[jd101]

Just got working with AppGini and so far I like it.

The application that i am building will basically be a co-ordination service for frequencies.

This allows the users to put in a request for a specific range they are looking to use. ( We allocate the specific frequency based on their requirements )

Putting a new request in is fairly simple task. Where I am having problems is that every year they are required to verify the information in their record to make sure no changes go undocumented.

These frequencies are published in a list for public use.

My problem is that at any time the user can go make a modification to the record without our approval. IN our case they might move their requirement area and be too close to someone else on the same frequency and cause interference for example.

What I am looking for is a way to moderate their proposed modifications to make sure that there are no issues before allowing it to become public record.

Is there something that someone has done that I can refer to or a way that this can be done natively?

Thanks

[a.gneady]

You could have 2 separate tables, one for requests and another one for approved assignments .. only the latter should be accessible publicly. You could either manually add entries to the approved frequencies table after approving them in the requests table, or add code to hooks to automatically copy approved requests to the public table once they are approved.

[jd101]

Thanks i'll try that.