Closed

App : pull from client calendar, fill out excel sheet & email sheet automatically

Create an app for both apple and android for monthly subscription (possible hybrid or pwa?)

App Title : Auto SAF

- Splash screen

-> Users log in and permitted to use app if subscription is paid. If subscription is active user is NOT required to sign back in, in order for app to automatically pull from calendars weekly

Users input details into app (only have to do this once)

- (first, last name, employee number, home station, ft or pt, employee address)

App pulls data from specific calendars and inputs into a excel form for each event in calendar. Different calendars will result in a different "type code" in the excel sheet

- Automatically run weekly on Thursdays

1) take events in a specific calendar ex. "+ banked time" and import data from each event into a specific excel template (separate form for each event)

a) date

- i) if e) "shift worked" ends with a "D" (to signify a day shift) the date is the same as the calendar event.

- i) if e) "shift worked" ends with a "N" (to signify a night shift) then the date is the same as the calendar event up until midnight.

Any event past midnight with the "shift worked" ending with an "N" will be dated the previous date of the calendar event. Ex. 0300 Jan 4, will be showed as 0300 Jan 3

b) start time

c) end time

d) "event number" 6 digit number pulled from title after shift worked.

e) "Shift worked" pulled from title (ex. 248A1D)

f) "Type code" - dependant of which calendar event is in

i) Calendar "+ Banked time" => Type code "Shift O/T " and "% Cash" = 0

ii) Calendar "OT" => Type code "Shift O/T " and "% Cash" = 100

ii) Calendar "Kilo Events" => Type code "Kilo Event Hours

iii) Calendar "EToD" => Type code "Extended Tour of Duty"

(both d) & e) would be written in the title if possible or what ever is easiest to imput

2) once complete, it would send email for each completed forms to a specific address w/ the subject as the date and shift worked for each individual client. The email sent would be shown with the reply to of the individual employees email and preferably show as if it was being sent from them

Subscription

- allows all access

Bonus work (not to be included in bid, please quote separately for bonus work)

- to populate all of this data into 1 excel sheet in table format for client to review before email being sent.

- create log or other way to prevent duplicate entries being sent.

- night mode (based on sunset in pacific time zone)

Skills: Android, Mobile App Development, Excel, iPhone, HTML5

See more: client database excel, making client list excel, excel vba lock sheet user script, send email automatically, client database excel free, excel pull outlook calendar, client database excel sheet, client list excel sheet, email excel file automatically, send excel files via email automatically, excel macro send email automatically, excel email sheet, event calendar excel sheet, excel fill form email automatically, excel macro to send email automatically, automatically update data in excel from one sheet to another, how to send excel file to email automatically, this event was automatically added to your calendar from email by outlook., email one sheet of excel workbook 2016

About the Employer:
( 0 reviews ) Burnaby, Canada

Project ID: #30170742

15 freelancers are bidding on average $593 for this job

(397 Reviews)
8.2
(107 Reviews)
7.6
(123 Reviews)
7.7
techradr

Hello!I’ve carefully gone through your job posting of mobile app.I ’m an expert with more than 5 years [login to view URL] already have team of 20 members and we already have done many changeless tasks in past and still doi More

$750 CAD in 35 days
(29 Reviews)
6.5
daydreamsofthiru

◆ I can help you create an app ANDROID + iOS for a monthly subscription. ◆ Can we please connect to a chat for a discussion about bonus work? ▶▶▶▶Do have a look at some of my HYBRID works: -> [login to view URL] More

$500 CAD in 7 days
(9 Reviews)
5.8
maxpl

Hello, I hope all is well there. I am an experienced web developer. I have 8+ years of experience in webdesign/development. I ha More

$600 CAD in 7 days
(4 Reviews)
5.3
balrajdhami

Hye dear client, I read and understand to build app for British ambulance service to autofill excel sheet and emails sheet ,I have gone through teh attachment for the sheet need to filled using application. Also I hav More

$850 CAD in 7 days
(2 Reviews)
4.1
saadtariq329

Hi There, Your job posting clarifies that you’re in a search of innovative developer for your interactive project. Here you got perfect person as I’m energetic, pioneering & ground breaking developer. I invite you for More

$500 CAD in 7 days
(4 Reviews)
4.1
RavenSolutions

Hey! I have read about your project App : pull from client calendar, fill out excel sheet & email sheet automatically I am KickAss in Excel, HTML5, Android, iPhone and Mobile App Development, so I'am totally sure I can More

$555 CAD in 3 days
(3 Reviews)
4.0
ThefactorE

Hello!! We are an IT company with whole team for mobility, website and other application development working for over 10 years with many successful projects. We ensure you get the work done as soon as possible within More

$500 CAD in 7 days
(2 Reviews)
2.8
(3 Reviews)
2.3
mildlogix1

Hello!Hope you are doing great.I have read that you need an android/ios app.I have been developing iPhone and Android applications for 4+ years now.I am proficient in building custom Android (Phone and Tablets), iOS (i More

$750 CAD in 35 days
(1 Review)
1.8
Ndxjdh

I am an expert pos system ,mongo DB VR,matlab, perl, Java/C++ , linux ,developer, Html 5, Hosting PHP, MySQL, Word press, Woo Commerce, Shopify, React, jQuery, PSD to HTML, PSD to CMS, bootstrap, material design, PHP More

$350 CAD in 10 days
(1 Review)
0.0
DesignzbyFaiza

Hi there I have gone through your requirements and understand that you are looking for a app developer who can make an app for you. I an interested in your project. I want to know that do you have UI design/ front end More

$444 CAD in 30 days
(0 Reviews)
0.0
arnoldb

Hi, I hope you are doing well. I am full stack developer from Poland with more than 8 years of experience. I have gone through all your requirem More

$600 CAD in 7 days
(0 Reviews)
0.0