Code To Count Number Of Video Views

[swest]

What would the code look like to count the number of times a user clicks on a video to view it? Where would I place this code, in the video player in server events? Thanks for any help!

[Davidk]

Re: Code To Count Number Of Video Views

Some details would be nice. Grid, UX, what video player, how are you invoking it. There are literally a billion ways to get stuff done in Alpha... including some reference or a sample component would help.

If it's on a button, then you'd have a data-bound field which hold the video view count. When you click the button, get the current count, add 1 to it, and save that value back to the table.

[swest]

Re: Code To Count Number Of Video Views

It would be a button it a grid component. So you are saying to create a database field to hold the count in the table and then do what?

[Davidk]

Re: Code To Count Number Of Video Views

It really depends on what you want to do. You haven't said... but if it's a button in each row of the grid, then I'd assume you're playing a video that is distinct... per row. If your grid is editable, your table would have a video count column. Include that count field in the grid and hide it. When you click on the button, using .setValue() to update the count field and save the row, then play your video.

[swest]

Re: Code To Count Number Of Video Views

When someone clicks on an image in a grid component it plays a video. What I want after the image is clicked to play the video, I want to add 1 view to a count column in a database table. What I have so far is an action javascript that does an ajax callback to xbasic code that fires after the video player action javascript. The xbasic code I have so far is below, the error it is giving me is Invalid summary field type:

define class Count
dim userid as n


userid = select id from (table_name) where id = :id
UPDATE (table_name) set count = count + 1 where id = userid

end class

Sorry for confusion, does this help to explain it?

[Davidk]

Re: Code To Count Number Of Video Views

Is that everything in your XBasic? Where is :id coming from? Where are you executing the code to get userid. userid would have to be an argument for the Update statement.

You have this in a class? Why?

If this is everything, then stuff isn't right, and can be adjusted. If you've left out code, then post the full code.

I understand your concept better now that you've explained it... and it's what I thought you wanted to do.

[swest]

Re: Code To Count Number Of Video Views

It is all the code I have right now, I know it isn't right. It should be pretty simple to do but not sure about the code. Any help would be appreciated!

[Davidk]

Re: Code To Count Number Of Video Views

I would first try a simpler route. You can certainly call XBasic code... but first... let's see if we can use the Grid for this.

Is your Grid editable? And... can you add a field to the table your Grid is based on... something like "videoCount"?

[swest]

Re: Code To Count Number Of Video Views

It is not editable but I have a count field that is selected in the grid. I can change the count field to editable.

[Davidk]

Re: Code To Count Number Of Video Views

Good... change the count field to editable. Now... on the image you click to run the video... how are you actually running the video? With Action Javascript? If so, then add another Action Javascript to the one you've already defined. It's action will be "Inline-Javascript".

Your "Inline-Javascript" code will be...

var rowNum = {Grid.RowNumber};
var currCnt = {grid.Object}.getValue('G','VIDEOCOUNT',rowNum);
currCnt = parseInt(currCnt);
currCnt = (isNaN(currCnt) ? 0 : currCnt);
currCnt += 1;
{grid.Object}.setValue('G','VIDEOCOUNT',rowNum,currCnt);
{grid.Object}.submitGridPartRow(rowNum);

Maybe move this Action Javascript to the top so that it will run first. Maybe it doesn't matter.

Here we get the current Row number we're on. Then we turn it into an Integer. If it's currently an empty field, we test for it being NaN.
If it is Nan we'll use 0, and if not we'll use the number we got. Add 1, then use .setValue, and then save the row.

[swest]

Re: Code To Count Number Of Video Views

It works however with it being editable, however the user can change the vote count which I don't want them to be able to do. If I change the count field to unedited then the count field doesn't update. Anyway I can change it so the user cant edit the vote count?

[Davidk]

Re: Code To Count Number Of Video Views

Sorry, I meant to add that you can use the "Hide column" property of your count field.

[swest]

Re: Code To Count Number Of Video Views

Sorry, I want the user to be able to see the number of video views. Isnt there some code that will update the field but not allow the user to change it but be able to see the number?

[Davidk]

Re: Code To Count Number Of Video Views

We'll get this yet...

Unhide the column, and in that column's "Enable expression" property put 1=0. Now, the column will be disabled from User's input, but not from our .setValue.

[swest]

Re: Code To Count Number Of Video Views

That works! Thanks for your help!