[For Kodular]How to make Comment system using ChatView?

In this guide I will describe you to make comments system and managing it using your own Database.

What you will need

Here is a list of items/resources you will need before getting started…

How it looks from Designer

Here is its design…

scrnli_11_4_2019_6-00-18%20PM

scrnli_11_4_2019_6-00-18%20PM376×640 11.6 KB

Components

Following have been used in making this comment system-

  • Button
  • TexBox
  • ChatView
  • Notifier
  • Web
  • Clock

Note:- If you want to show comments in ListView Image and Text then replace ChatView by it

Pre-added rows/tables

If you are continuing this guide then I assume you have created a Table named ‘Comments’ and four rows named as following-

  • Timestamp
  • Id
  • User
  • Comment

Blocks

Blocks are divided into three parts…

1.Save comment in database

blocks%20(64)

blocks%20(65)

I am running an INSERT command to add the given data to the table.

Command: INSERT INTO `Comments` (`Timestamp`, `Id`, `User`, `Comment`) VALUES (‘timestamp‘,’id‘,’image_url */* username‘,’comment‘)

You can use a condition block to check whether query was successful or not.

2.Load comments from Database

blocks%20(67)

blocks%20(66)

blocks%20(66)1261×917 79.2 KB

I have called all the comments from the table and added to chatview.

Since the data will be returned in the same format as it was added, I have split the data to get a list of values.

3.Load comments for specific ID

blocks%20(68)

I am calling comments for a specific using WHERE clause so comments will be returned only for specific id.

Again we shall have to decode it in such a way that we can use it with ChatView.

 

Extras
‘runQuery’ Procedure:-

blocks%20(69)

blocks%20(69)1075×321 29.7 KB

 

Universal ‘Got Text’ event

blocks%20(70)

blocks%20(70)1261×1125 96 KB

Procedure to get ‘id’ for Chat View
blocks%20(71)

Result

comments

comments321×570 23.3 KB

Apk File

Comments.apk (5.1 MB)

Aia File

Here is Aia file download Link:-

Comments.aia (71.6 KB)

 

Hope it helps!

Subscribe
Notify of
5 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
nivu_techy
1 year ago

nice

10 months ago

Ok

bibek barman
10 months ago

Now not work this app