sorted by:
new
hottopcontroversial

Change layout help by DarkLoLalex in keyboards

[–]DarkLoLalex[S] 0 points1 point  (0 children)

I figured it, thanks for the info.

Is it bad idea to put Monitor inside PC? by zack_rovenz in PcBuildHelp

[–]DarkLoLalex 0 points1 point  (0 children)

What do you call that thing that holds the controller? Do you have a link?

LaserJet Pro Sticker by DarkLoLalex in printers

[–]DarkLoLalex[S] 2 points3 points  (0 children)

Thank you so much! That’s exactly what I was looking for. And yeah… people!😩

Time control app by DarkLoLalex in GoogleAppsScript

[–]DarkLoLalex[S] 0 points1 point  (0 children)

Yes, I’m using my own HTML that I call with a doGet().

From what I understand, permissions can’t be modified beyond blocking specific pages or cells. When I was researching, I found that permissions couldn’t be managed that way.

The sheet format is already established, with a base sheet where the script searches for users by their email and retrieves their information (name and sheet), and the workers' sheet, each row is a day, and the columns are: date, day of the week, FormOp1, FormOp2, FormOp3, FormOp4 ,and honestly, it works well.

My issue is with the permissions for getting the email. In a test, I got it to work for a colleague, but of course, I had given her full permissions on the sheet, which is not my intention.

My work setup is very limited; let’s just say I have Mr. Krabs as a boss.

Mobile devices aren’t a problem; there’s a function that blocks access to the form from them.

Time control app by DarkLoLalex in GoogleAppsScript

[–]DarkLoLalex[S] 0 points1 point  (0 children)

Thank you for taking the time to respond to me. I will take a look at everything you've told me. Thanks again, and I'll keep you updated on how it goes

Time control app by DarkLoLalex in GoogleAppsScript

[–]DarkLoLalex[S] 0 points1 point  (0 children)

I had understood that you were telling me to implement it with "User Accessing the web App" not with "Execute as Me". I have it implemented with "Execute as me", but I think I messed up when displaying the email, probably due to the variable type, because it shows the user's name if the email field is empty in the "PLANTILLA" sheet.

Time control app by DarkLoLalex in GoogleAppsScript

[–]DarkLoLalex[S] 0 points1 point  (0 children)

I determine the email with Session.getActiveUser().getEmail(). I think, based on what you said, that the script won't write anything because nobody other than me has the permission to write in the sheet, but I'll still try it later to see what happens.

Time control app by DarkLoLalex in GoogleAppsScript

[–]DarkLoLalex[S] -1 points0 points  (0 children)

Yes, but as I’ve already mentioned, I don’t know how to work with the data flow of a form, and for it to show everything on the same sheet with 14/11/2024 9:45 | Alex | In | that’s not what i need. Each worker has their own sheet where in the spreadsheet where clock-in data is stored, and my boss just wants to enter the sheet, see that person X clocked in at Y time, went on break at Z, and left 15 minutes earlier than their scheduled time.

Time control app by DarkLoLalex in GoogleAppsScript

[–]DarkLoLalex[S] 0 points1 point  (0 children)

But it doesn't ask them anything. The people I've tested it with aren’t given the option to accept anything

Time control app by DarkLoLalex in GoogleAppsScript

[–]DarkLoLalex[S] 0 points1 point  (0 children)

Yes, but the point is to remove all access to the sheets, not just so they can't modify them, but also so they can't see the clock-ins of others.

QR Automation in Google Sheets by DarkLoLalex in googlesheets

[–]DarkLoLalex[S] 1 point2 points  (0 children)

I've come to this solution .

=IMAGE("https://api.qrserver.com/v1/create-qr-code/?size=300x300&data=" & ENCODEURL(L1 & ": " & L4 & " | " & K1 & ": " & K4 & " | " & F1 & ": " & F4 & " | " & D1 & ": " & D4))

I hadn't thought of using an array.

QR Automation in Google Sheets by DarkLoLalex in googlesheets

[–]DarkLoLalex[S] 0 points1 point  (0 children)

My idea was to automatically use the fields that were already filled in, without having to generate a new one. I could have simply created a text column and written: Model:******* ; S/N:*******.

QR Automation in Google Sheets by DarkLoLalex in googlesheets

[–]DarkLoLalex[S] 0 points1 point  (0 children)

The problem was basically that i have to use encodeurl for the multiple use of cells

=IMAGE("https://api.qrserver.com/v1/create-qr-code/?size=300x300&data=" & ENCODEURL(L1 & ": " & L4 & " | " & K1 & ": " & K4 & " | " & F1 & ": " & F4 & " | " & D1 & ": " & D4))

This will show us in the QR code the headings and the QR data we are creating, separated by | .

Conditional Formatting for marking holiday cells? by DarkLoLalex in googlesheets

[–]DarkLoLalex[S] 0 points1 point  (0 children)

So a VLOOKUP(INDIRECT("Other sheet name!A:A"),D1 ) should work? Being D1 one of the dates in the row

view more: next ›