There are a way to know the current online users in my app

Itโ€™s possible to know whoโ€™s online from my users in my app ! 

Solved Solved
1 12 878
1 ACCEPTED SOLUTION

Hi Hassan,

There could be several aspects to this:

  1. You can go to Manage -> Monitor -> Usage statistics, to have a basic view about who have been using your app, but perhaps unless you are on an Enterprise plan, this information wouldn't be sufficient.

  2. You can add "creationTimestamp", "createdBy", "editTimestamp" and "lastEditedBy" columns to your tables to track the times and owner of changes to your rows. The first two columns would be changed only once through an Editable if constraint of: ISBLANK([_THIS])

  3. Also, you can track changes to only specific column(s), not just any column, in your row, by adding a Change-type column to your table:
    Tracking Changes Using "Change" Column Types | AppSheet Help Center 

  4. If tracking changes is not sufficient and you want to track who has seen your app, then you can do the following: 
    1. Create a userLog table. This table would contain the following columns: "userEmail", "timestamp" and "viewName" column of type Text. The table should allow only addition of new rows and no edits to existing rows.

    2. Your app has a number of different Views, and now you should decide what are the Tracked Views you will use as basis for user tracking.

    3. All of your tracked views above should be accessible only from a main menu. This is an example from an app of mine:
      Capture dโ€™eฬcran 2022-03-20 aฬ€ 17.05.09.png
      This view is actually a sub view of a parent view, and each line of the shown child view, when clicked, will send the user to a new view.

      Here's how to do it:
      Solved: How do i make a home screen with images taking the... - Google Cloud Community  

      And this is a sample app that you can copy, applying the same concept:
      Icon Main Menu 

      In this step, you should have done the following:
      1. Created a new table for the Main Menu, with a row for each sub view. This table will contain a "viewName" text column containing the text to show next to each corresponding view image in the Main Menu view. 
      2. Created a new Behavior Action named for example: goToSubView
      3. Assigned goToSubView as an Event Action in the UX view of Main Menu.

    4. Go to Behavior and create a new Action for the Main Menu table, let's name this action trackView. This action should be set as below: 
      • For each record of this table: Main Menu
      • Do This: Data - Add a new row to another table using values from this row
      • Table to add to: userLog
      • Set these columns:
        • userEmail: USEREMAIL()
        • timestamp: NOW()
        • viewName: [viewName]

    5. Again, in Behavior create a new Action for the Main Menu table, let's calle it menuClickEvent. Set this action as follows:
      • For each record of this table: Main Menu
      • Do This: Grouped - Execute a sequence of actions
      • Actions:
        1. userLog
        2. goToSubView

    6. Last step and you are all set. In UX go to the Main Menu view, scroll down to Behavior inside the view, and in the Event Actions, select menuClickEvent instead of goToSubView. 

Tell me if you face any difficulty. 

View solution in original post

12 REPLIES 12

@Joseph_Seddik  ุฌูˆ ู„ูŠู‡ุง ุญู„ ุฏูŠ ูˆู„ุง ุงูŠู‡ ูŠู†ูุน ุงุนุฑู ู…ูŠู† ุงูˆู†ู„ุงูŠู† ู…ู† users 

@Hassan_Tanna ุงุฒูŠูƒ ูŠุง ุตุฏูŠู‚ูŠ ๐Ÿ™‚
ู„ูˆ ู‚ุตุฏูƒ ู…ูŠู† ุงู„ู„ูŠ ูุงุชุญ ุงู„ุงุจู„ูŠูƒูŠุดู† ุฏู„ูˆู‚ุชูŠ ุญุงู„ุงู‹ุŒ ู…ููŠุด ุทุฑูŠู‚ุฉ ู…ุจุงุดุฑุฉ.. ู„ูƒู† ู…ู…ูƒู† ู…ุซู„ุงู‹ ุชุนู…ู„ ุญุงุฌุฉ ุฒูŠ ุฑูŠุจูˆุฑุช ุชุดูˆู ููŠู‡ ู…ูŠู† ุนู…ู„ ุฅูŠู‡ุŒ ุจุฃูƒุชุฑ ู…ู† ุทุฑูŠู‚ุฉ..
ู‚ูˆู„ ู„ูŠ ุงู†ุช ู…ุญุชุงุฌ ุฅูŠู‡ ุจุงู„ุถุจุท ูˆู‡ู†ุดูˆู ู„ู‡ุง ุตุฑูุฉ ๐Ÿ™‚

ุญุจูŠุจูŠ ูŠุง ุฌูˆ ุงู†ุช ุจุชุงุน ุงู„ุญู„ูˆู„ ูƒู„ู‡ุง ๐Ÿ˜‚ ู‡ูˆ ุงู†ุง ูƒู†ุช ุนุงูŠุฒ ุงุดูˆู ู…ุซู„ุง ู…ูŠู† ุงูˆู† ู„ุงูŠู† ุจุณ ู…ู…ูƒู† ู…ุซู„ุง ุญุงุฌู‡ ุฒูŠ last seen ูƒุฏู‡ 

ุงู„ุงุจูŠู„ูƒูŠุดู† ุฏุง ุงู†ุง ุนู…ู„ู‡ ุญุงุฌู‡ ุฒูŠ crm and erb  ุจุณุชุฎุฏู…ู‡ ุงู†ุง ูˆุงู„ู†ุงุณ ุงู„ุดุบุงู„ู‡ ู…ุนุงูŠุง ุจุณ  

ู‡ูˆ ุดุบุงู„ ุชู…ุงู… ุฏู„ูˆู‚ุชูŠ ุจุณ ุงู†ุง ุจุญุท ุงู„ุชุงุชุด ๐Ÿ˜‚

ุฃูŠูˆุฉ ูƒุฏุฉ ุชุณู„ู… ุฅูŠุฏูƒ ๐Ÿ™‚

ู…ู…ูƒู† ู†ุนู…ู„ last seen 
ุนู† ุทุฑูŠู‚ automation

ู‡ุงุฑุฌุน ุงู„ุจูŠุช ูˆุงุถุจุทู‡ุง ูˆุงู‚ูˆู„ ู„ูƒ

ุฎู„ุงุต ุชู…ุงู… ๐Ÿ‘ 

 

@Joseph_Seddik  ุจู‚ูˆู„ูƒ ูŠุง ุฌูˆ ุฏุงูˆู‚ุชูŠ ุงู†ุง free plan ุนู„ูŠ appaheet ูˆุนู…ู„ุช automation ูŠุฌูŠู„ูŠ ุงู…ูŠู„ ู„ูŠุง ุงู†ุง ุจุณ creator  ูƒุฏู‡ ุนุงุฏูŠ ูˆู„ู…ุง ู…ู…ูƒู† ุงู„ุงุจ ุดูŠุช ูŠู‚ูู„ูŠ ุงู„ุงูƒูˆู†ุช ุนุดุงู† ุงู†ุง free plan

ุนุงุฏูŠุŒ ุนู†ุฏูƒ ู„ุญุฏ 10 ุฅูŠู…ูŠู„ุงุช ู…ู†ู‡ู… ุงู†ุช ููŠ ุงู„ุจู„ุงู† ุงู„ู…ุฌุงู†ูŠุฉ.. ุงู„ู…ู‡ู… ุงู†ูƒ ุชูƒูˆู† ู…ุชุญูƒู… ููŠ ุงู„ุฅูŠู…ูŠู„ุงุช ุงู„ู„ูŠ ู…ุฏูŠู‡ุง ุงู„ุญู‚ ุงู†ู‡ุง ุชูุชุญ ุงู„ุฃุจู„ูŠูƒูŠุดู† ุจุชุงุนูƒุŒ ูˆู…ุง ุชุนุฏูŠุด ุงู„ุนุฏุฏ ุฏู‡..

Hi Hassan,

There could be several aspects to this:

  1. You can go to Manage -> Monitor -> Usage statistics, to have a basic view about who have been using your app, but perhaps unless you are on an Enterprise plan, this information wouldn't be sufficient.

  2. You can add "creationTimestamp", "createdBy", "editTimestamp" and "lastEditedBy" columns to your tables to track the times and owner of changes to your rows. The first two columns would be changed only once through an Editable if constraint of: ISBLANK([_THIS])

  3. Also, you can track changes to only specific column(s), not just any column, in your row, by adding a Change-type column to your table:
    Tracking Changes Using "Change" Column Types | AppSheet Help Center 

  4. If tracking changes is not sufficient and you want to track who has seen your app, then you can do the following: 
    1. Create a userLog table. This table would contain the following columns: "userEmail", "timestamp" and "viewName" column of type Text. The table should allow only addition of new rows and no edits to existing rows.

    2. Your app has a number of different Views, and now you should decide what are the Tracked Views you will use as basis for user tracking.

    3. All of your tracked views above should be accessible only from a main menu. This is an example from an app of mine:
      Capture dโ€™eฬcran 2022-03-20 aฬ€ 17.05.09.png
      This view is actually a sub view of a parent view, and each line of the shown child view, when clicked, will send the user to a new view.

      Here's how to do it:
      Solved: How do i make a home screen with images taking the... - Google Cloud Community  

      And this is a sample app that you can copy, applying the same concept:
      Icon Main Menu 

      In this step, you should have done the following:
      1. Created a new table for the Main Menu, with a row for each sub view. This table will contain a "viewName" text column containing the text to show next to each corresponding view image in the Main Menu view. 
      2. Created a new Behavior Action named for example: goToSubView
      3. Assigned goToSubView as an Event Action in the UX view of Main Menu.

    4. Go to Behavior and create a new Action for the Main Menu table, let's name this action trackView. This action should be set as below: 
      • For each record of this table: Main Menu
      • Do This: Data - Add a new row to another table using values from this row
      • Table to add to: userLog
      • Set these columns:
        • userEmail: USEREMAIL()
        • timestamp: NOW()
        • viewName: [viewName]

    5. Again, in Behavior create a new Action for the Main Menu table, let's calle it menuClickEvent. Set this action as follows:
      • For each record of this table: Main Menu
      • Do This: Grouped - Execute a sequence of actions
      • Actions:
        1. userLog
        2. goToSubView

    6. Last step and you are all set. In UX go to the Main Menu view, scroll down to Behavior inside the view, and in the Event Actions, select menuClickEvent instead of goToSubView. 

Tell me if you face any difficulty. 

ุงู†ุช ุนุงู„ู…ูŠ ูˆุงู„ู„ู‡ ุญุจูŠุจูŠ ูŠุง ุฌูˆ ุงู†ุช ุชู‚ุฑูŠุจุง ุนู…ู„ุช ุงู„ุงุจู„ูŠูƒุดู†  ูƒู„ู‡ ๐Ÿ˜‚  ู„ุงุฒู… ุงุดูˆููƒ ูˆุงุชุนุฑู ุนู„ูŠูƒ ุจุฌุฏ 

Itโ€™s working thank you joo ๐Ÿ™

ู„ุง ูŠุง ุฑุงุฌู„ ุชุณู„ู… ุฅูŠุฏูƒ ๐Ÿ™‚ ุฃู†ุง ู…ุจุณูˆุท ุจุงู„ู„ูŠ ุงู†ุช ุนู…ู„ุชู‡ ๐Ÿ‘

ุฅู† ุดุงุก ุงู„ู„ู‡ ู„ู…ุง ุฃู†ุฒู„ ู…ุตุฑ ู‡ุงู‚ูˆู„ ู„ูƒ ูˆู†ุชู‚ุงุจู„ ุฃูˆ ุชุนุงู„ู‰ ุฒูˆุฑู†ูŠ ููŠ ู…ุฏุฑูŠุฏ ุชู†ูˆุฑู†ูŠ ๐Ÿ™‚

ุญุจูŠูŠ ูŠุง ุฌูˆ ูŠุง ู…ุดุฌุนู†ูŠ ๐Ÿ˜ุงู†ุดุงู„ู„ู‡ ุงุดูˆููƒ ุนู„ูŠ ุฎูŠุฑ ููŠ ู…ุตุฑ ุงูˆ ู…ุฏุฑูŠุฏ ๐Ÿ˜Š

thankyou for this!

Top Labels in this Space