New field via web update records option ?

[roattw]

Hope that title makes sense.  We have a very basic form.  One person submits the form and the results of the form go to a target group of people involved. After receiving the initial form responses, members of the group need to be able to respond with thoughts of their own on the matter at hand.  But we need to log and track the additional comments that are made.

So we have an Additional Comments field the users can access by going to Caspio, looking at that last entry and choosing EDIT record, then type some new info in the Additional Comments field.  Not bad.  But if each user with additional comments has input, all they can do is Add it to the end of the previous persons entry in the text field.  With a lot of discussion this text field could get long with no real way to tell who added what to this growing Additional Comments field.

In a perfect world, when a user Edited the form, they would see a blank Additional Comments form in the Edit field.  They would add there comments and exit.  New comments get recorded as separate entity and, when finished, the next person with a comment to provide would get a blank Additional Comments field. Their entry appended to last comment entry.

Does that make any sense?

 

[MayMusic]

You need to have another table with these fields:

User_ID, Topic_ID, Comment, Date Submitted

So you can keep the track of all comments. For instance look into this article

http://howto.caspio.com/getting-started/create-a-one-to-many-relationship/

http://howto.caspio.com/tech-tips-and-articles/tech-parameters/how-to-create-a-one-to-many-relational-datapage/

 

In this example "Customer Details" in Topic, " Customer Log History " is Comments and "New Log" is to add new comment.

 

[roattw]

This helps a lot.  Im struggling a little with the HTML block they want to call the Details page they use in there example tutorial.  Instead of giving me a link Im getting the HTML just dispalyed:

 

 

[roattw]

Figured it out.  The source code editor was converting quote marks to &quot;    and  the <a href> brackets to &lt; and &rt; 

[roattw]

After a lot of learning the nuances I finally got this to work.  Thank you!  All new comment  go to a new table and are logged in a history, just like the examples.

Is there a way to get those new comments fields from the new table into my main parent table, so when I export excel reports its not a seperate report/spreadsheet?

[aam82]

Yes, lookup Views in the Caspio documentation. A View can combine Tables by joining them on matching ID fields.

[roattw]

This is working ok.  However, it creates a new entry in the table for each new comment added.  Can it APPEND to an existing table (ie the tabe grows with each entry)?