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

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

Learn how to hack this @agung_taufik1 [image] Exploring the Enhanced Capabilities of Glide's Native Form Community Resources 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…

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

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

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

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

[image] Himaladin: custom form I’ll try…thanks

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.

[image] Darren_Murphy: Distance to Location oh great, thanks for the idea

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

If you just want a column containing the current date, you should use a Math column: [CleanShot 2024-10-23 at 14.07.08@2x]

Activate location automatically or required

Ask for Help

Himaladin October 23, 2024, 2:02am 2

Learn how to hack this @agung_taufik1

Topic		Replies	Views
Location validation Ask for Help	20	1135	January 12, 2023
Near map, then they can Submit their presence Ask for Help	5	421	December 21, 2021
Form to Check IN & Check OUT Ask for Help	2	390	March 13, 2023
🧭 Location Component General	61	6389	April 5, 2023
Location Check-IN Ask for Help	1	338	August 19, 2020

Activate location automatically or required

Related topics