Active button

[trizo]

Hello, is there anyway for me to make a button that shows if someone is available or not. I still want to see my data in the spreadsheet without it getting deleted. 

[Aurelien · Accepted solution]

Hi @trizo 

You may need a "Status_Active?" column, type Yes/No.

Action button: Switch_Status, with expression:

NOT([Status_Active?])

 And apply a Format Rule, so that it turns green if active.

For example:

[Aurelien · Accepted solution]

Hi @trizo 

You may need a "Status_Active?" column, type Yes/No.

Action button: Switch_Status, with expression:

NOT([Status_Active?])

 And apply a Format Rule, so that it turns green if active.

For example:

[trizo]

Hi @Aurelien thanks for helping me, much appreciated. So I'm a bit confused should I make a new column in my sheets or in Appsheet self?

[Aurelien]

Both.

First in your Sheets

Second in AppSheet, in your app editor. Data>Columns>Regenerate Structure.

For reference:

Add, remove, or rearrange columns - AppSheet Help

[trizo]

I don't see the other options?

I can't see the other options on top?

[Aurelien]

@trizo 

"I can't see the other options on top?"

Format rules ? 

Have a look in UX>Format Rules

[trizo]

Haha my bad let me have a look real quick

[trizo]

Thanks a lot! 
One last question. How do I separate it from Available and not Available. 
Example all the people who is there at the moment and there toggle is on available, names should be on top else if it's off there names should not be on top.

[Aurelien · Accepted solution]

"Group By" options on the Table view 😉