HR Portal App - by Robert Petitto

[alan_singer]

I discoverd the hR Portal app by Robert Petitto on the glide resources page link to the Applications for sale section.
Let me say I was filled with a sense of awe (at the layout, the use of the screen real estate, the functionality beyond CRUD) coupled with great excitement as for the first time, I was seeing an app that I had been hoping could be produced with glide but I had never seen one like that in real life.
Sad to say that up until now, my work with Glide is just a series of CRUD patterns for a range of tables plus a heap of relationships that can store, retrieve and update information (but not really do anything with it)
@Robert_Petitto at the risk of possibly asking you to reveal some of your magic tricks, can I ask some questions about how you have crafted aspects of this app (which I consider to be an absolute masterpiece!)

QUESTION 1.
IS this a particular component? How have you created this?

QUESTION 2
I now see this is a table component

[Darren_Murphy]

@alan_singer

QUESTION 1.
IS this a particular component? How have you created this?

That would be a Big Numbers component inside a container. The container looks to be using a background image with a gradient effect applied.

[Robert_Petitto]

@alan_singer thanks for the kind words! Yes, big numbers in an image container. What was your second question related to the table?

[alan_singer]

@Robert_Petitto

Great application - Well done Robert!

I initially thought you were using grids but then I realised it was a table

I have a different question…In the recruitment section, how have you configured the Job Roles section?

Also how have you done this - Is this using containers?

Are you handling many to many relationships - Can you have the same candidate applying for multiple roles?

The thing that is really challenging me at present is how to implement many to many relationships

This is the objective…

QUERY 1
There is a table (i call it “stored-files”) that consists of a collection of rows that each hold one file (pointer) per row - a “stored files” table). The application allows files to be associated with records from the people table. a File will be associated with one or a number of people records. Query 1 is to be able to search for a record in the stored-files table and then see all the people who have been associated with the file record

QUERY 2
for every stored file, I want to be able to see all the people that have been linked to the file.

Is the following a viable / approach and is it the preferred approach?

UPDATE*
I actually set up a relation in the People table that says when the Row ID of the current people row is equal to the RowID in the related record (FK) field of the file record, create a tag THis has created tags for the related records but the problem is the relationship does not show up as a source of data when I try to build teh query

Any comments or guidance greatly appreciated

[alan_singer]

Hi @Robert_Petitto Thnanks again - I have added a couple of other questions about your app below - Very keen to hear your thoughts
Alan