# Component Visibility **URL:** \ **Category:** Ask for Help\ **Created:** [January 3, 2020, 6:27am UTC](https://community.glideapps.com/t/component-visibility/3289 "2020-01-03T06:27:05Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Bhupendra](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bhupendra/32/788_2.png) [@Bhupendra](https://community.glideapps.com/u/Bhupendra)\ **Post date:** [January 3, 2020, 6:27am UTC](https://community.glideapps.com/t/component-visibility/3289/1 "2020-01-03T06:27:06Z")
![button-error](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/f/f397fa4346d1d2584116f3ae532ec23572c87c49.jpeg) What is Visibility status of button in three different case as per seen above case-1, case-2, case-3 ? ---
**Author:** ![Doomba](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/doomba/32/1133_2.png) [@Doomba](https://community.glideapps.com/u/Doomba)\ **Post date:** [January 3, 2020, 9:43am UTC](https://community.glideapps.com/t/component-visibility/3289/2 "2020-01-03T09:43:50Z")
Case 1: Won’t be visible (because date is before today) Case 2: Will be visible (because date “is after” today) Case 3: Will be visible (because date “is on” today’s date) ---
**Author:** ![Bhupendra](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bhupendra/32/788_2.png) [@Bhupendra](https://community.glideapps.com/u/Bhupendra)\ **Post date:** [January 4, 2020, 4:49am UTC](https://community.glideapps.com/t/component-visibility/3289/3 "2020-01-04T04:49:12Z")
Thank @Doomba, I known that , But not working in my case… I have Two Sheet 1st is “5-CE-IT” 2nd is “Recheck.” In “5-CE-IT” sheet Students Result data store., Student View his result and if he want to apply for recheck then apply for recheck by click on button. I wants this button active up to particular date (Date field in 5-CE-IT sheet). This recheck data submitted by form in Recheck Sheet. ![recheck](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/a/a30ee4328d27cb6e2937e074faeec66ae8d0f1dd.jpeg) Also one thing is that student, only one time applied for recheck. For this use isReCheck switch. I use arrayformula to check student applied for recheck or not by Status of isRecheck. I want to active button only when student not applied for recheck ( isRecheck = False) and Recheck date is not due. > **[Mid Examination Results](https://docs.google.com/spreadsheets/d/1J-j843asMPbgWb9z9nj8bjqzMGsNYkIZRKZK6JNBezY/edit)** > > Profile > > Group,Image,Enrollment No,BR CODE,Name,Email,Mobile,Gender,Admission year,convoyear,SEM1 SPI,SEM2 SPI,SEM3 SPI,SEM4 SPI,SEM5 SPI,SEM6 SPI,SEM7 SPI,SEM8 SPI,CGPI,Category > Student,090670106001,6,PATEL POOJA Arvind... My Problem is that Button is always active even if Date is over and arrayformula not working. Have you any solution??? ---
**Author:** ![Doomba](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/doomba/32/1133_2.png) [@Doomba](https://community.glideapps.com/u/Doomba)\ **Post date:** [January 4, 2020, 7:59am UTC](https://community.glideapps.com/t/component-visibility/3289/4 "2020-01-04T07:59:35Z")
What is the array formula you’re using? I’m not able to open the spreadsheet, please allow access to anyone with the url. ---
**Author:** ![Christophe\_HK](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/christophe_hk/32/4161_2.png) [@Christophe\_HK](https://community.glideapps.com/u/Christophe_HK)\ **Post date:** [January 4, 2020, 8:33am UTC](https://community.glideapps.com/t/component-visibility/3289/5 "2020-01-04T08:33:18Z")
Are you using the per user data feature to analyze the isRechecked per student? Also regarding the dates, try the US format for the dates, this could be the issue (aka mm/dd/yyyy instead of dd/mm/yyyy) ---
**Author:** ![Doomba](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/doomba/32/1133_2.png) [@Doomba](https://community.glideapps.com/u/Doomba)\ **Post date:** [January 4, 2020, 11:42am UTC](https://community.glideapps.com/t/component-visibility/3289/6 "2020-01-04T11:42:26Z")
I would recommend a column in the spreadsheet itself with TRUE/FALSE values for visibility status, based on any combination of multiple criteria. Then use that column to show/hide the Rechecking button. ---
**Author:** ![Bhupendra](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bhupendra/32/788_2.png) [@Bhupendra](https://community.glideapps.com/u/Bhupendra)\ **Post date:** [January 6, 2020, 5:19am UTC](https://community.glideapps.com/t/component-visibility/3289/7 "2020-01-06T05:19:23Z")
Thanks @Doomba I solve Date problem. I Change date format in US. Now Help for Arrayformula [[https://docs.google.com/spreadsheets/d/1J-j843asMPbgWb9z9nj8bjqzMGsNYkIZRKZK6JNBezY/edit?usp=sharing](https://docs.google.com/spreadsheets/d/1J-j843asMPbgWb9z9nj8bjqzMGsNYkIZRKZK6JNBezY/edit?usp=sharing)] ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [January 6, 2020, 5:41am UTC](https://community.glideapps.com/t/component-visibility/3289/8 "2020-01-06T05:41:05Z")
Try `=arrayformula(IF(LEN(A2:A) = 0, "", IF(ISERROR(VLOOKUP(A2:A,Recheck!A2:A, 1, FALSE)),"FALSE", "TRUE")))` ---
**Author:** ![Bhupendra](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bhupendra/32/788_2.png) [@Bhupendra](https://community.glideapps.com/u/Bhupendra)\ **Post date:** [January 6, 2020, 5:57am UTC](https://community.glideapps.com/t/component-visibility/3289/9 "2020-01-06T05:57:23Z")
Thanks @doomba and @Jeff_Hager Its works… 😍