Unanswered

Help needed to design an ERD for a solution !!

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello team,

I hope that someone might have come across this situation. I want to create a solution with the following requirements. This is a portal for job applications.

1) User can register on the website first if he/she does not have a login or else he/she can log in.

2) Once logged in, they have the option to choose jobs to apply for. Let's say they choose 2 jobs.

3) Once they choose jobs, each job has a different set of questions. Let's say Job1 has 15 questions and job2 has 20 questions. Do I need to create a separate table for each type of job as the number of questions is different? How can I set up an entity and create forms based on this?

I look forward to see if someone has created a similar solution.

Kind Regards,

Hafiz

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Sort by

ragavanrajan 7,044 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @Anonymous

Yes you can do this in Power Pages.

1. By default, the user can register to the Power Pages

2. You can configure the authentication by following the official ink. please click here

In terms of the Data model

1. You may need to create a different table like Jobs, questions

2. Create a relationship between jobs and questions

3. Use the Multi-step form to configure your questions according to the job: Official link

Tip: You can also use a subgrid to display different questions.

Have fun.

Hope it helps.
------------

If you like this post, give it a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users to find it.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thank you @ragavanrajan for your response. It is really helpful indeed. I have a question regarding looking at the application. Let's say if an admin wants to see how many applications a user submitted, how he can see this. It seems that we should have 3 tables.

1. Contacts
2. Jobs
3. Question

These will have relationships. Is there a way to write a view to get columns from different tables like we do in SQL?

Kind Regards,
Hafiz

Was this reply helpful? Yes No
ragavanrajan 7,044 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

You are welcome @Anonymous.

If my understanding is right, the admin person wants to view the total number of applications submitted i.e. combination of contacts linked to the jobs table.

The simple way to achieve your need is to build a fetch XML using link-entity

Official link:

Tip: Use the XRMToolbox fetch XML builder

https://www.xrmtoolbox.com/plugins/Cinteros.Xrm.FetchXmlBuilder/

Have fun.

Hope it helps.
------------

If you like this post, give it a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users to find it.

Was this reply helpful? Yes No