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

Closed Posted 2 years ago Paid on delivery
Closed Paid on delivery

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)

Android Mobile App Development Excel iPhone HTML5

Project ID: #30170742

About the project

14 proposals Remote project Active 2 years ago

14 freelancers are bidding on average $582 for this job

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
(3 Reviews)
2.9
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