Overseas Workers? Yes.
I require an Expert with deep Google Data STUDIO knowledge, integrations with other 3rd party apps such as Power BI, FLOURISH. Must be smart, fast and be ready to start work right away. Thank you.
Hello, We are looking to make a Google Sheet / Forms / Scripts based Attendance System for our employees with the following details: 1. Capture their in-out movements at different locations during the day. 2. Mandatory selfie clicking at all locations 3. Tagging geo-location at the place of filling the form. 4. Calculate the distance travelled during the day. A reference video is attached:
Hello, we are looking to create a Google Forms / Google Sheets task deligation sheet using mix of the following 2 videos: 1. 2. We want the following from video 1: 1. Delegation master And from 2nd video the following: 1. Auto Whatsapp and Email to Doer once task delegated. 2. Updation feature Job-ID wise. 3. Auto Daily Task Pending Reminder on Whatsapp and Email to Doer & Delegator in text and pdf formats. 4. Once Task get Complete by Doer Delegator will get task completion notification on whatsapp and Email. Weekly MIS Scoring Doer Wise. Any additional input from your side which may improve our business efficiency are also welcomed and can be integrated.
We have Zoho one license and are using Zoho books and Zoho CRM. Most other processes are being done on Google sheets/ Excel We want to bring 95% of our processes on Zoho platform with zero effort duplication. Includes Automating entire quote-to-dispatch process + reporting including (but not limited to) - pricing lists - auto stock look-up for quote assistance (including leveraging equivalent word dictionary) - quote comparison table - material in/out daily reports (planned-for-future and executed that day) - Issuance of PO - Acceptance of PO/ Sales order generation - Generation of packing list/ Delivery Challan - material physical check inputs and outputs - instruction cards for maintenance jobs - capability of matching equipment by specifications and dictionary -Sourcing team performan...
Bills of Quantity (BOQ) automation based in google sheets using arrays and concats.
Authentication: Store at user level - once a user is signed in, doesn’t need to sign in again. Authenticate using our server’s backend authentication mechanism Authentication credentials to be hosted in sidebar Data sources and APIs Each workbook should be created from a template. It will have Cover page One or more presentation tabs Control sheet with details of APIs to be called and reference of source table destinations One or more Data tables tabs data table APIs to be called initially to populate metadata A set of data table APIs to be called subsequently with dynamic queries (read from cells) Data Update Auto refresh of APIs at hourly or longer intervals (user option) Refresh of APIs through user action (refresh button) Handle pagination Auto Archiving Reports to be ...
I have a long pivot table in Google Sheets, I need to display the weighted average in 2 of the columns, so I need to apply a custom field formula there, but I have some values with blank spaces and I'm getting errors. Additionally need to display those 2 columns in %, I also want to highlight the total rows, haven't found a way to do this. Will award immediately if we can get it fixed right away. Thank you.
Need to sync QuickBooks online with google sheet I found a software that does the sync G-Accon but need someone that can use their tool to customize my sync Or recommend another tool. I'm attaching a sample of the google sheet I created, but at this time, I do double accounting and enter the data manually from QB online to the google sheet. Please see an attached sample I'm using in google sheet If you read this email, please respond with the keyword "Magnolia" so ill know you are not a bot
1. Create script to connect seet with mysql database 2. Create function to select table and search by field and display variable 3. Create function to display a table from mysql into sheet