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 875
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’écran 2022-03-20 à 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’écran 2022-03-20 à 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