How to prevent the emergence of the topic to add the user on the scree

Hi,
you need to create admin security group and assign add permissions for this group only on the User group permissions dialog on the Visual Editor tab.

Hi,

thanks jane
but I want to prevent the emergence of a new thing if accept by admin

It's hard to understand you.

Do you want to assign add permissions on the generated page?

In other words,
I need to add a new field called ( Approved ) with authority for the admin group only

so that the other groups editing and inserting for rows ( cars for example ) would not be listed on the page until the admin approves the new data throw check that field.

There are some tips:

1. add new field Approved to your table,
   
2. create custom view of your table on the Datasource tables tab. Set up permissions for the custom view for admin only on the User group permissions dialog on the Security tab.
   
3. Add Approved field to the add/edit pages of your custom view only on the Choose fields tab.
   
4. add Where clause to the SQL query of your main table on the Edit SQL query:
   

   select ...
   

   
   from TableName
   
   where Approved=1

There are some tips:

1. add new field Approved to your table,
   
2. create custom view of your table on the Datasource tables tab. Set up permissions for the custom view for admin only on the User group permissions dialog on the Security tab.
   
3. Add Approved field to the add/edit pages of your custom view only on the Choose fields tab.
   
4. add Where clause to the SQL query of your main table on the Edit SQL query:
   

thanks jane
i try this and reply you

where create custom view and how <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=31830&image=1&table=forumreplies' class='bbc_emoticon' alt=':(' />

To create custom view of your table proceed to theDatasource tables tab, select table and click on the Add View button.

thanks jane
icreate filed approved in table cars and put sql command where approved=1

but when edit edit filed approved=1 by page edit the main page no appear anything to guset
plese help me

I'm no sure that I understand you.

Please explain step-by-by-step what you're doing.