Results for "expense account management google sheets"

Hello,

You might use the Google Drive app (desktop) to automatically sync your excel spreadsheet to the cloud. Then you can access it from Google Sheets.

If you need to post process the file, then it's a different topic. And if you have Excel you should maybe do it in Excel directly with PowerQuery. Otherwise on Google Sheets you could use some Scripts or formulas, which is best depending on your target.

So we got this biometric attendance device at work. Vertex-HCM. Works really well actually - fingerprint scan is fast, employees like it, no more buddy punching.

Only problem is it exports data as an Excel file. Then I have to manually copy-paste into Google Sheets. 50 employees, daily work, takes forever.

The device itself is solid. No complaints there. But I want to automate the Google Sheets part.

Has anyone connected a biometric device to Google Sheets directly? Using API or Apps Script? Maybe there's a way to auto-import the CSV?

I asked Vertex-HCM support if they have a Google Sheets integration. They said they're working on it but nothing yet. So trying to figure out a workaround myself.

Anyone done something similar? I know basic Apps Script but API integration is new to me.

hi,

code fixed for the update.

Thank you so much.

That has solved my problems.

That when you activate the active sheet and populate the fileds and save it. Then you should be able to edit the submitted data by activating the active sheet and search using year and month criteria to populate the other fields. Edit and hit the update button.

Thank you

hi,

It is not working as expected

How do you expect it to work?

It is not working as expected so I want to change it to the combobox. Am asking to clarify if its only the search textbox to be changed to combobox or any other one. Thank you

Hello,

First of all, is this working as expected?

Take my suggestion for what it is "I would do it differently", but if you are happy with how it works, there is no need to change.

Thank you. Please if I get you clear, you are suggesting that, the search textbox should be changed to combobox.

Kindly help me with the fixes and where to reduce the number of fields.

Thank you

Hello Vickwa,

I made some fixes to your code to make it work, but it's not optimal. I would reduce the number of fields, make use of combobox instead of textbox, ...

Please I am having problem with userform to activate a sheet then searching with two criteria that is by year and month to populate other fields and then update.Kindly assist me. Iam new to vba. Thank you

Have attached the file