Wage Spreadsheet

30.0 GBP

30.0 GBP peopleperhour 技术与编程 海外
4天前

详细信息

I have 2 spreadsheets that needs checking which is what we use for hours worked for each employee and it calculates holiday and bank holiday pay etc.We are finding a few issues with the formulas not working correctly in certain cells and the info from certain tabs not feeding across correctly.Are you able to check over both spreadsheets for any errors please? Also password protect the cells that shouldn't be changed?All cells and formulas need checking please on all sheets to check if everything working correctly. Forget about the password protection.ThanksSusie

免责声明

该外包需求信息来源于站外平台,本站仅提供公开信息部分字段展示与订阅服务,更多请查看免责声明

关注公众号,不定期副业成功案例分享
关注公众号

不定期副业成功案例分享

领先一步获取最新的外包任务吗?

立即订阅

类似推荐

A developer is needed to build a dynamic landing page on Carrd.io that will parse URL parameters and validate offer codes via a Make webhook. The page will check if an offer ID, member email, and expiry date sent in the URL are active in Airtable. It will call a Make scenario to validate against offer, member, and redemption data and return status messages to the user. The successful candidate will provide thoroughly documented JavaScript, HTML, and CSS to extract parameters, make API calls, and display responses based on validation checks for inactive offers, expired codes, or prior redemptions. The goal is a simple, low-cost solution within existing Carrd Pro Plan, Make, and Airtable plans. I am happy to do the work in Make and Airtable myself but I need workable JS code so I expect it to be a quick job for someone with relevant skills. Budget ~GBP£100. DETAILED BRIEF: **Project Overview** I am seeking a freelance developer to assist with the implementation of JavaScript for a landing page built on Carrd.io. The landing page will parse three URL parameters and send them to a webhook in Make for validation. The results will then be returned to the landing page to indicate whether the offer is valid or invalid. **Current Setup** - **Platform**: Carrd.io for the landing page. - **Webhook**: Currently configured in Make to process incoming data. - **Data Source**: Airtable Base containing promotion and member data. **Key Requirements** 1. **JavaScript Development**: Provide the necessary JavaScript code for the landing page to handle URL parameters and webhook interactions. 2. **Webhook Configuration**: Review and assist in setting up the Make webhook scenario to ensure it correctly returns responses to Carrd.io. **Use Case** 1. Diner member is sent a QR code by email 2. Presents this to restaurant staff who scan it using device camera and it opens a browser 3. The url goes to a landing page 4. The url has parameters for Offer Code ("offerID") and member's email address ("email") and expiry date ("expirydate") used for validation checking and additional parameters used to display on the landing page as static text, “offer description” and “offer conditions”. **Validation Workflow** When the "VERIFY OFFER" button is clicked by restaurant staff on the landing page, the following checks should be performed via Make and Airtable: 1. **Offer Validity**: Check if the offer ID is marked as "Active" in the "Offers" collection. 2. **Member Validity**: Validate the member's email against the "Members" collection to ensure it is "Active". 3. **Redemption History**: Check the "Redemptions Logs" collection to see if the member has previously redeemed the offer using their email and offer ID. 4. **Expiry Check**: Ensure the current date is before or on the expiry date from the URL parameter. **Response Messages** Based on the validation checks, return the following messages: - If the offer is inactive: "OFFER IS NO LONGER AVAILABLE" - If the member is inactive or not found: "USER NO LONGER A MEMBER" - If the offer has been previously redeemed: "NOT VALID, PREVIOUSLY USED ON [date]" - If the offer is expired: "OFFER EXPIRED" - If valid, create a record in the Airtable's Redemption Log Table with the validation date, member's email, and offer ID. **Instructions Required** - Detailed, step-by-step instructions for building the landing page, including: - Element IDs - JavaScript code - Configuration settings for Make and Airtable - Simplified language suitable for a non-technical user. **Considerations** - Aim for a low-code solution to minimize complexity. - Keep costs within existing subscriptions (Carrd, Make, Airtable). - Avoid potential CORS issues. - Anticipate low validation volume. **Additional Information** Please let me know if you require further details on the current setup or specific technologies in use to provide a competitive quote.
100.0 GBP 技术与编程 peopleperhour 海外
1小时前