Jump to content
  • 0

New field via web update records option ?


roattw
 Share

Question

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?

 

Link to comment
Share on other sites

6 answers to this question

Recommended Posts

  • 0

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.

 

Link to comment
Share on other sites

  • 0

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?

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...