Suljettu

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)

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

Näytä lisää: 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

Tietoa työnantajasta:
( 0 arvostelua ) Burnaby, Canada

Projektin tunnus: #30170742

15 freelanceria on tarjonnut keskimäärin $593 tähän työhön

(397 arvostelua)
8.2
(107 arvostelua)
7.6
(123 arvostelua)
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 Lisää

$750 CAD 35 päivässä
(29 arvostelua)
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] Lisää

$500 CAD 7 päivässä
(9 arvostelua)
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 Lisää

$600 CAD 7 päivässä
(4 arvostelua)
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 Lisää

$850 CAD 7 päivässä
(2 arvostelua)
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 Lisää

$500 CAD 7 päivässä
(4 arvostelua)
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 Lisää

$555 CAD 3 päivässä
(3 arvostelua)
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 Lisää

$500 CAD 7 päivässä
(2 arvostelua)
2.8
(3 arvostelua)
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 Lisää

$750 CAD 35 päivässä
(1 arvostelu)
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 Lisää

$350 CAD 10 päivässä
(1 arvostelu)
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 Lisää

$444 CAD 30 päivässä
(0 arvostelua)
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 Lisää

$600 CAD 7 päivässä
(0 arvostelua)
0.0