Slice for active users

[Preeti123]

I need to create a slice that shows active user only. We have users for 3 months, 1 month,1 week and for 1 day.

Im applying [access end date]> today but its not working.

[Lynn]

Hi @Preeti123 

Could you please post the exact expression you are using.

Also have you checked out this article?

https://help.appsheet.com/en/articles/2357327-today

[Preeti123]

 It should be automatically changed in active if access duration is under 3month,1month, 1week and 1 day.otherwise it will show expired.

[Preeti123]

I have a column [Access status] in this I want to put "Active " if [Access End date] value is greater than today() else return "expired".

How can I implement this?Also I need view of active and expired separately, It already made. Active status column is  not being updated.

[rakhie_urs]

You create two different slices of table with filter conditions

[Access Status]=Active

and

[Access Status]= Expired

[Preeti123]

I tried this way but  it should be generated  automatically like I have end date of access, if I compare it with today n it will equal or less than then show active else show expired.

[Joseph_Seddik]

If you want to have it your way, then you can make your “Access Status” column virtual. Its formula will calculate on every sync, but it will recalculate every time for all rows in your table. 

A better way is to use slices and base its filter condition on your “Access End Date” column. Here you won’t need an “Access Status” column. 

[rakhie_urs]

[access end date]>=today()

should work

It ll show only users whose status is active till date

[Preeti123]

If Im checking in app its showing active and expired separately but in my
google sheet status is not updating...

[Joseph_Seddik]

You have to make the column virtual in order for its formula to recalculate.

[Preeti123]

Yes that is a virtual column.

[Joseph_Seddik]

Please show the column's configuration and the expression you're using. Thanks.

[rakhie_urs]

Data once entered will not change unless its by an action.

schedule an action through automation that updates the column values of status daily.

[Joseph_Seddik]

This is not true. Columns with formulas will recalculate with or without an action:

1. Column App Formulas will recalculate for one particular row with any and every data change in any column in that row.
2. Additionally, formulas for virtual columns will recalculate, for all rows, with every sync. 

[rakhie_urs]

Yeah @Joseph_Seddik ,  Virtual column will recalculate but it won't enter any data into the sheet right?

[Joseph_Seddik]

Right. They don't exist in the sheet. 

Normal columns will also recalculate for one particular row with any data change in any column in that row. 

[SkrOYC]

Hi @Preeti123  

Can you share with us your current table schema?

We have read from you two different things. One related to a slice and another about an Access Status column.

For the first one, you need to troubleshoot since your expression seems right, but we don't have any clue if the column's config is right or not.

About the status, there are different ways to solve it, I can think of 2, seems like both were mentioned above.

1. The worst: Virtual column with an IF() checking if the end date is in the future
2. The best: Bot that checks this daily and changes the status column based on a condition. This is the best one because there is no slowdown added to your app on every sync and the load is on the server

[Preeti123]

Im new to appsheet please help me to create bot for status changed.

[Preeti123]

I'm using this expression

 Still column values are not updated as I expected

 I need to sync with previous rows also. But could be the solution of it

[rakhie_urs]

You need to schedule a bot to update column access status

[Preeti123]

Appreciate your help.

How can I create bot for that. Please help me 

[rakhie_urs]

Add me on Telegram +918050611676