How to set up the database for a comments system

James_Vador · 2020-05-31T19:18:49.042Z

Hi ,

I would like to implement a book “comment/feedback” section in my app.

I have set 2 databases:

Data Type “book”
Field “Author”, “title” , “comment” (with a field type “list of comments”

Data Type “Comments”
Field " comments" (text) , “book” (with a field type “book”)

I have created a multiline input where users will put theirs comments and a button that will create a things “comment” in the comment database and i wanted to add the book title with te current page book title but it is not working, is my database setup correct ?

Thank you in advance,
Best regards,

James_Vador · 2020-06-01T21:57:37.096Z

up please

J805 · 2020-06-01T22:22:41.474Z

It seems like you are in the right direction. Maybe show some screenshots to help us see what’s going on?

James_Vador · 2020-06-02T09:30:09.162Z

Thanks for your reply, you will find here below some screenshots of my database and the workflow used to store comments, my issue is that i don’t know how to do to have the book title in the comments data type

Capture d’écran 2020-06-02 à 10.36.03

I have set up a group with information like author, title …etc.
I have created a multiline input feedback caption and a “submit button”

Capture d’écran 2020-06-02 à 10.37.14378×596 49.3 KB

In the workflow of the button i created a new things for “comments” data type and i linked it to the “feedback data field”. The feedback are stored in the comments database but i don’t know how to do for the “book title” which is linked to “book” datatype

Capture d’écran 2020-06-02 à 10.39.38

Capture d’écran 2020-06-02 à 11.27.05898×182 19.1 KB

I hope it is clear, do not hesitate if you have additional questions.

Regards

J805 · 2020-06-02T13:25:12.975Z

Hey there

I’m not in front of my computer right now but let me see what I can do.

So if you set another field from the submit button step 1 you can choose

book title = current page book

Maybe you should label that field as “parentBook” instead of “Book title” as it may be confusing.

Then you can also do this as step 2:

Make changes to a thing > current page book

Add field: “Comments” Add Step 1’s Comment

Let me know if you need me to do screenshots and I can do that later for you.

Want to learn more?

www.nocodeminute.com

Presenting

I hope that helps!

James_Vador · 2020-06-02T21:30:37.789Z

Thanks, it worked !!!
I have just one remaining issue, i have set up a repeating group to list all the comments. I would like to have one comment per row but it seems that all the comments are listed in the same row.
I have put here below the screenshot of the comment database and the repeating group

Capture d’écran 2020-06-02 à 23.11.02

Capture d’écran 2020-06-02 à 23.27.39644×584 92.8 KB

Capture d’écran 2020-06-02 à 23.27.22638×575 90.2 KB

Capture d’écran 2020-06-02 à 23.23.01

Thank you in advance for your help !

J805 · 2020-06-02T21:42:19.847Z

No problem. It should be the current cell. Not the current page. That should be what you are looking for.

James_Vador · 2020-06-03T19:33:20.804Z

Thank you very much for you help, everything is working fine !!!

system · 2020-08-09T19:18:54.496Z

This topic was automatically closed after 70 days. New replies are no longer allowed.