About Sinethemba_Gayi

Paid User Account · 06-24-2019

Hi, I have clients that are interested to use Apps, but they want to use the App on a time to time basis. I wish to ask therefore, what happens when an App is not paid on month 3 but paid again on month 5?

Sinethemba_Gayi · 05-28-2019

Hi, On the Timesheet App, I would like to create sites and have Employees on a Dependable selection based on the Site they are stationed at. Once an employee visits their site, the employee should Scan either a QR Code or NFC to be able to Clock-In a...

Increase App Users · 05-21-2019

Hi, If I currently use the Free app with access up to 10 users and need to create additional 5 users. Will I be billed for a total of 15 users or just the 5 extra users?

Sinethemba_Gayi · 05-09-2019

IFS( HOUR([Total Hours]) >= 8,“08:00:00”, TRUE,[Total Hours] ) I get this error on the above formula “IFS function is used incorrectly:Inputs to IFS() must be condition-value pairs. Input 4 is not a value of a consistent type.”

Sinethemba_Gayi · 05-09-2019

I am working on the Timesheet App and have been advised that to in order to achieve calculation of Overtime Hours, I need to set Time In and Time Out to DateTime formula. Using the Now() initial value, this functions optimally in Time In but when a U...

Sinethemba_Gayi · 05-31-2019

Fabian: Please try this expression: DISTANCE(LATLONG(-32.943227, 27.762631) , HERE()) < 1 Or you insert an extra column in your Sheet, let’s say “Location” and enter the LatLong value of the site. In the AppSheet editor the Type of this column must b...

Sinethemba_Gayi · 05-31-2019

Fabian: Please try this expression: DISTANCE(LATLONG(-32.943227, 27.762631) , HERE()) < 1 Thank you so much, this worked perfectly!!!

Sinethemba_Gayi · 05-31-2019

Aleksi: Now you can sum last months total pays with the virtual column like… SUM( SELECT(Timesheet[Total Pay], AND( YEAR(EOMONTH(TODAY(),-1))=YEAR([Date]), MONTH(EOMONTH(TODAY(),-1))=MONTH([Date]), [UserName]=[_THISROW].[UserName] ))) Thanks @Aleksi,...

Sinethemba_Gayi · 05-31-2019

@Fabian on the Time In column, In the Valid_If expression I get this error: “Unable to find column ‘(-32.943227, 27.762631)’” I inserted App formula: DISTANCE([(-32.943227, 27.762631)] , HERE()) < 1

Sinethemba_Gayi · 05-28-2019

Hi @Aleksi , any tips as to how I can achieve “I would probably do this with an extra table with one column (employee emails). When you have that table, you can calculate your numbers with virtual columns”? I would really appreciate it!

My Stats

Sinethemba_Gayi's Bio

Badges Sinethemba_Gayi Earned

Recent Activity

Paid User Account

Timesheet App - QR / NFC Location Authenticator

Increase App Users

IFS function is used incorrectly:Inputs to IFS() must be condition-value pairs. Input 4 is not a value of a consistent type

DateTime Formula returns 12/30/1899

Re: Timesheet App - QR / NFC Location Authenticator

Re: Timesheet App - QR / NFC Location Authenticator

Re: Monthly View / Report on Timesheet App

Re: Timesheet App - QR / NFC Location Authenticator

Re: Monthly View / Report on Timesheet App