Activate location automatically or required

[agung_taufik1]

hi, I’m trying to make an attendance application, is there a way to enable location automatically, or at least required?

[Himaladin]

Learn how to hack this @agung_taufik1

Exploring the Enhanced Capabilities of Glide's Native Form

I want to share about the additional capabilities that we can achieve with Glide’s native form. What I have tested with the help of CSS is that native forms can also be applied for validation. [Screenshot 2024-01-23 at 07.10.39] Create your validation in the table columns and present it through messages via the “hint” component. Add the visibility conditional and the class “prevent-submit” to these hint components. Add the following CSS code: /*Container Form*/ #page-root:has(.prevent-submi…

[agung_taufik1]

thanks for the info…
because of the free version, I can’t apply CSS yet

[Himaladin]

Another way is that you use a custom form with a custom action to control your submit button.

[Darren_Murphy]

Just curious - what is the purpose of capturing the location upon check in?

[agung_taufik1]

because this is an attendance application, I want every employee who comes in to be in the office area…
and I’m developing it, if the employee who comes in is within 1km of the office, that can’t be done

[agung_taufik1]

@Himaladin

custom form

I’ll try…thanks

[Darren_Murphy]

Okay, that’s what I thought.
So I assume you have the coordinates of the Office location?
Assuming yes, add a Distance to Location column that compares the users current location with the Office location. Then you can only allow them to Check in if that distance is less than the threshold that you set, and there is no need to ask for their location in the form. As long as the users allow location sharing when the App is opened, that will work.

[agung_taufik1]

@Darren_Murphy

Distance to Location

oh great, thanks for the idea

[agung_taufik1]

May I ask again, how do I apply Excel formulas in GT? I wrote today but what appears is numbers

[Darren_Murphy]

If you just want a column containing the current date, you should use a Math column:

[agung_taufik1]

ok thank you very much…
Can this date reference make the visibility of the check in button disappear?
For example, today I was absent from coming in and absent from going home, when I was absent from going home, the button will disappear, and will be available again the next day…

[Darren_Murphy]

It’s possible, it’s just a matter of clearly defining the rules, and then building the logic.

Questions:

• do users also Check Out, or do they only Check In?
• if they also Check Out, do you update the existing (Check in) row, or create a new one?

[agung_taufik1]

@Darren_Murphy

• do users also Check Out, or do they only Check In?
• if they also Check Out, do you update the existing (Check in) row, or create a new one?

1. The user checks out
2. yes… I updated the existing check in line (row)

[Darren_Murphy]

Okay.

So if a user Checks in on one day and then forgets to Check out, what should happen on the next day? Do you just forget about the previous day and leave the Check out empty?

Let’s assume yes. I would do something like this…

First, in your Check ins table I would have 3 columns for dates:

• Check In (Datetime column)
• Check Out (Datetime column)
• Date (Number column in the format YYYYMMDD)
• I also assume you have a column to store the users email address

Now in the table that the Check In/Check Out screen is attached to, create the following columns:

• Math column to return the current date in YYYYMMDD format:

Year(Now)*10^4
+Month(Now)*10^2
+Day(Now)

• Query column that targets the Check In table, with the following filters:
  – Email is signed in user
  – Date equals This row->math column
• Lookup column that fetches the first check out time via the query column
• Single Value->First->Whole row column via the query column

To decide if a user needs to check in or check out, use an if-then-else column:

• If Query column is empty, then Check In
• If Lookup column is empty, then Check Out

When a user Checks In, you will always add a new row.
When a user Checks Out, you will update the existing row via the Single Value column

[agung_taufik1]

wow great, thanks for the perfect explanation, I’ll try, I’ll ask for your advice again if I encounter any difficulties

[agung_taufik1]

@Darren_Murphy

add a Distance

Is there a limit to calculating distance in the free package?

[Jeff_Hager]

I would think it should be fine as long as you are using coordinates. An easy test would be to add more than 10 rows.

[Himaladin]

Use JavaScript to calculate the distance without being affected by this limitation. However, I’m not sure yet if there are any restrictions when using the location button in the free plan.