Adding Forms, or merging Zoho Creator with Zoho DB & Reports

Adding Forms, or merging Zoho Creator with Zoho DB & Reports

Hello Zoho makers,


=====================================
I need something like the following model:

Shared Forms:
for users to enter data

Private Database Manipulation:
for me to automatically merge, classify, ... data

Shared Views:
for users to view the well classified data.
=====================================
If I understood Zoho correctly, I found that:

Zoho DB | Reports has the Database Manipulation and the View Feature,
but no Form feature.

Zoho Creator has the Form and the View Feature,
but no complex data manipulation and merging.

That's the reason for my suggestion.
=====================================
Anyway, I'll tell what I'm currently on since it seems to be a very general example:

I'm currently playing a game called "cypher"
http://cypher.extremecast.com/

This is a (unrealistic) "hacking" simulation, with some role playing features.

Players can group into "factions" with up to 25 members.

The most exciting, fun and important part of the game is information
about other players, such has "what player has this ip address", or
comments like "this guy will probably hack our whole factions tomorrow".

We need toshare information between faction members easily, and fast.

Obviously a database is the best possibility.
I'm currently holding on my computer an odb "open-office database" file,
for our faction information.

odb has Forms+ Data manip + views, but odb is not online.
Faction members have to send me info often.
An online database would be the best.

But there can be spies from other faction in our faction, so I don't want to
allow every member to edit right into the database, and I would like to
keep a log about who entered what info, so Forms are needed.


I'm currently trying to implement it with both Zoho Creator and Zoho DB.
But in the video example with Zoho DB + Zoho Creator,
it shows how to implement a scheduled import from Zoho DB to Creator,
and the whole data of Creator is imported each time.
This is not effective.
The data should be imported only each time a user fills the form, and only
the new data should be imported. Also, once imported I dont need to keep
 the data in Creator. Also the import should declenche data merging,
and view updating.

==================================

Can you roughly explain me how can I combine Creator+DB to do that,
while Forms are still absent from Zoho DB & Reports?

==================================

Thank you in advance.

Zoho seems to be a very powerful service, keep up the good work!
I'll probably use it for my next job too.

Hades