MS D365 CE (CRM), Flow and Forms dev

Budget 500$ per month
Posted: 5 years ago
Opened
Description
My company website is a custom site in SquareSpace (SQS). I have a Resources page that contains files that a site visitor can download as well as fiels that can be downloaded from other pages. My original site developer and I came up with a way that I can "gate" that content for download with a Jotform to capture visitor data for lead generation which then integrates back to my current CRM (Zoho).

However, the process of getting a new file up is VERY multi-step! Oh, and I hate Zoho ;)

I would like this made much, much simpler and more streamlined from an admin perspective. AND to help me get closer to getting off Zoho completely.

What I'm looking at is using an MS Forms form (MS' choice of products names these days makes sentences awkward!), replacing the Jotform as JF doesn't have a direct integration to D365 CE, to capture the data and an MS Flow to connect the Form to D365 and then a D365 plugin and/or workflow(s) to generate a response email with the link to the file the visitor wants, which would be stored in a SharePoint Online library, back to the site visitor. On the SQS site, the files would be represented by a link, a thumbnail, or a graphic/shape (depending on the requirement for the specific page).

This would be for files on the Resources page as well as other pages in the site.

The event flow would be:
1. Visitor accesses Resources page (or other page with files I want to "gate" with the lead gen form) and locates file they are interested in
2. Visitor clicks 'view' button (on Resources page only) and the file opens using Google docs application (existing functionality to either be duplicated or kept and refactored/wrapped) which opens in a fully restricted popup window (no copying, downloading, etc., and no nav controls)
3. The visitor decides they want to download the file and clicks 'download' button (when on Resources page, on other pages might just be a link or some other button or graphic)
4. The new lead gen form, from MS Forms and connected to D365 CRM via Flow, opens to capture data. Form would require field and data validation.
5. Visitor completes the form and submits which invokes MS Flow to connect to D365 CE.
6. The values entered would first need to be cleaned somewhat as follows:

a) Fname field limited to a single contiguous word except where a hyphen is used (ex. Tommy-Lee)
b) Lname field any and all abbreviations stripped off (ex. "MBA", "R.N.", "PMP", "ITIL", etc.) and limited to a single contiguous word except where a hyphen is used
c) Neither Fname nor Lname fields to allow single character (an initial in other words). Minimum 2 characters
d) Company name data would need to be reduced/simplified (ex. "Randstad", "Randstad Canada", "Randstad Staffing", "Randstad Professional", "Randstad International", and any other variations like that to all be reduced to be "Randstad")
e) The Country, state/prov, and city fields (with cascade relationships) are easy since those will be controlled values. Theses lists and the cascade relationships need to be created.
f) Email field should have a format mask but also disallow using webmail domains such as outlook.com, hotmail, gmail, yahoo, etc. That way the visitor would be pushed harder into using an email address with their business/work domain. I say pushed harder because I doubt there is a source out there (unless you know of one?) that has a comprehensive listing of all of those webmail type domains. Regardless, that should be a variable that queries a list I can add to/change.

7. Once the data from the form is cleaned, D365 checks if any lead or contact records exist with matching or SIMILAR data (using the built-in pattern matching capability in D365 CE)using a concatenated string value of Fname+Lname+Country+Company+Email address and then iterates back through dropping email address and then again dropping company (account). If no matching/similar data found in any of the 3 iterations, create new lead record with an entry into a new custom "downloaded files" list entity to identify what file was downloaded.
8. If MATCHING lead or contact data found, D365 CRM to add a new record for the file the visitor downloaded to the downloaded files list and send a notification email to a specified D365 user (configurable) to follow up.
9. If SIMILAR lead or contact data found, D365 CRM to create a new lead record and send a notification email to a specified D365 user (configurable) to review/resolve.
10. If visitor replies to the auto-generated email containing download link, create a CASE in Service module.

From an admin perspective, what I would like is to be able to just add the file into the specific library in my SPO tenant, assign metadata values to it which would include the page/section to appear on, create the link/thumbnail on the page in the site, and have the "plumbing" take of the rest.

BUDGET is $400 USD
Skills:
C#,JSON,Microsoft,Microsoft Sharepoint,Software Development,CRM,Dynamics,Microsoft Flow,General / Other Programming & Software,Microsoft Forms
Working conditions:
500
Category
Source: guru.com

Add a bid

days

Similar freelance jobs

safe 
...
6 months ago
safe$7
Hi Robert P. , I noticed your profile and would like to offer you my project. We can discuss any details over chat....
safe 
"Hello, I need to create a website based on a . psd design file. Please also specify the timeframe within which you can complete this. Technical requirements: Layout (not pixel-perfect, but close to it) Responsiveness (the website should properly adapt to different screen sizes and devices) Clean code......
safe 
Project Title: Delphi Code Feature Creation Using delphi: Check to see if this already exsits, if not: create a shedulled task to start my program on PC startup with highest permissions, with no password or prompt. program is called for example: C:\Program Files (x86)\Myfolder\myprogram. exe If it already......
safe 
I want to create a program for customers and sellers to be able to use, to create a template for there artwork and be able to size them to there specific needs. And be able to download them as pdf or png files. This program will benefit the clothing industry with the industry i am in....
safe 
Hi, I am not quite sure if what I am asking is possible but within my University degree there is a calculator program which only works on the HP Prime prime calculator, I own a Casio fx-CG50 AU. I was hoping to have this program converted into a format which is compatible with my Casio calculator, all......
1 year ago
safe 
I am looking for a skilled C++ developer to help with a real-time object detection system for my project....
1 year ago
safe 
Project Title: Correct Rcpp armadillo code Overview: I am seeking a skilled developer to fix a compilation error in my Rcpp armadillo code. The code is currently throwing a compilation error, and I need it to be resolved promptly. Requirements: - Proficient in Rcpp and armadillo library - Strong understanding......
1 year ago
safe 
Project Description: - I am looking for a freelancer who can combine all the columns of 2 rows with similar values in Telerik Reporting. - The combined data needs to be displayed in a table view. - Ideal skills and experience for this job include: - Proficiency in Telerik Reporting. - Strong understanding......
1 year ago
safe$250
Bonjour Dmytro M. , j'ai remarqué votre profil et je souhaite vous proposer mon projet. Nous pouvons discuter des détails via le chat....
safe 
Hello, I am looking to develop a unity soccer game with moves like score hero 1. Map with 1-3 stars achievments 2. engine to make the goals like i want 3. smooth game play 4. IAP , shop , buy lives 5. lives to play 6. finger smoothness touch 7. the level will be added automticlly to the map 8. rewind......
1 year ago
safe 
Project Title: Bootloader For Renesas RL78 mcu Description: I am looking for a skilled developer to create a bootloader for the Renesas RL78 mcu. The ideal candidate should have experience with Renesas RL78 mcu and be familiar with the development environment. bootloader code is ready need help for run......
safe 
I am using EMA´s (50/75/100/200),two Stoch (5/5/5 and 5/3/3), RDX Indicator and the Indicator "The Arty". For Short Positions the Prive has to be under the 200 EMA (the 100EMA under 200, 75 under 100, 50 under 75, NOT crossing) and for Long Positions over the 200 EMA ( 100 over 200, 75 over 100, 50 over......
1 year ago
safe 
My project involves using an Emotional Stroop Task to measure and assess attentional bias towards emotional stimuli. To do this, I will be using the Drift Diffusion Model which is an analytical model to study the human decision making process. My study will need to include 90 participants in order to......
safe 
I am looking for a WPF Developer for a long term project....
1 year ago
safe 
I'd like to extract tables from pdf invoices files. At this stage i really only want the products that are in the tables on the invoices. The only information i would like from the invoices is supplier date (received) location received. Within thetables i require stock code, product item, the unit measurement......
1 year ago
safe 
Im creating a config using 'openbullet 1. 4', everything added successfully, due i have 3 years of using openbullet, but this request i never faced it before!...
1 year ago
safe 
This position is responsible for verifying data quality reports and queries, correcting errors and also tracking them....
1 year ago
safe 
We are currently looking for developer to contact us on developing integration/plugin for below listed platform. Please drop me message on which plugin you're able to develop. Please send similar plugin portfolio of your previous work. The plugin need to ready for uploading to marketplace . ActiveCampaign.......
3 year ago
View all