About G_S

G_S · 03-03-2024

Hi I am having a check in and check out application for my employee.My problem is I am using now () Formula in Check in time , Which is taking the device current time , Problem is if I change the time in mobile device and I can able to check in at an...

Security Filter based on admin and user · 12-04-2023

I am having a table called EmployeeI have key value as [Email][Role] column I want to set a security filter that Admin role people can see all records and user can see only their records I used below expression but it throws error Expression which is...

G_S · 07-24-2023

I have creating leave management application I am facing one issue with weekends I have below columnStart DateEnd DateI have 5 column with number field, User will enter duration for each day , Each field will be show based on Start and End date If I ...

G_S · 11-30-2022

Hi I am having Five table Table A -----UserTable B---FloorTable C----GroupTable D----Group UserTable E----FilterIn Group table I am having three column name Group IDFloor-Ref of floor table Related Group UserIn Group User Table I have three columnIdU...

G_S · 10-14-2022

Hi I am using a link to open the appsheet application and land on the form view with prepopulated valueI am using below url:CONCATENATE(“https://www.appsheet.com/start/xxxxxxxxxxxxxxxxxxxxxxxxx?refresh=1&wipe=1”,LINKTOFORM(“View Name”,“Employee ID”,[...

G_S · 03-04-2024

HI I used UTCNOW()+5:30 but its does not give me current time Please help me with correct expression @AleksiAlkio

G_S · 03-04-2024

Hi @AleksiAlkio , Thanks for let me know , Can you please help me with any expression that give current time with UTC

G_S · 12-05-2023

No change , I am getting same error , I can't create separate table ,any suggestion to get with existing table @baba_sawane

G_S · 12-05-2023

Getting Same Errror @baba_sawane Table 'Employee' has an invalid security filter '=IF(any(select(Employee[Role], [Email ID] = useremail())) = "Admin",true,[Email ID]=USEREMAIL())'. The filter expression cannot reference the table being filtered.

G_S · 12-05-2023

Please suggest Expression if anyone find the solution 

My Stats

Janis_Majors's Bio

Badges G_S Earned

Recent Activity

Use Global time instead of device Time

Security Filter based on admin and user

Ignore Weekends Date and show the column based on date selection

Show specific value in enum list based on another table related list

Auto navigate to another view without any action

Re: Use Global time instead of device Time

Re: Use Global time instead of device Time

Re: Security Filter based on admin and user

Re: Security Filter based on admin and user

Re: Security Filter based on admin and user