Need help organizing some information

HelloFred thank you so much for your warm welcome!

I am going to go into more detail here because after about 10 days of trial and error, I have in fact dipped my toes into relationship tables!

I've included a screenshot of the first tab in my "Productions" table with some web-safe information added. Here I can add info on who was doing what position, which company was producing, what photographer was shooting, was this a commercial? If there is it'll add fields for cinematographer and director.  The way this is great too is I can see all the jobs people have worked on from their contact information entry, which really makes this entire thing very useful (especially when I'm done adding the last 10 years of jobs to this database!).

I have a relationship table setup in each job that shows which assistants I have employed oone additional field, if they were my lead or not. This is where i've stagnated and have stumped myself.

Fred WOW FRED LOOK AT THAT!

I'm going to poke around at this later tonight when i get more free time. Earlier in the day I had been playing around and took an alternate approach and I'm wondering if we'd be able to merge the two.

In the crew information Table on the production tab I added some fields to the assistant entry

"Day 1" "Day 2" etc (ultimately I would like there to be 8 days total, as, historically this has been all i would need to schedule.

Then on the "Crew information" tab of the production table

This is where I feel your CSS would come in handy, it could help me organize this better, PLUS, I don't want the table names to be "Day 1, Day 2, etc."

Is there a way in Ninox to use a formula to change the display name of a column in a table?

Ideally I would like to use something like:

let wS := 'Start Date' -4;
weekdayName(wS) + " " + day(wS)

This would make the name of "Day 1" column Monday 29

Again, thanks for being a sounding board and offering up your knowledge, its very much appreciated.

Fred - i've taken some of your advice and have started to completely rework this, however I'm stuck on using your "raw(color())" function, i cannot get ninox to correctly recognize it. I'm clearly doing something wrong regarding the loops but after a day of poking at it I cannot figure out where the issue is.

let getLaborData := (WorkingPositions order by WorkDate);
let getUniqueDates := unique(getLaborData.WorkDate);
let data := for loop1 in getUniqueDates do
        {
            date: format(loop1, "dddd DD"),
            worker: (getLaborData[WorkDate = loop1] order by Position).{
                name: text(Assistant),
                type: Position
            }
        }
    end;
let css := "
    <style>
        .outsidetable {
            width: 100%;
        }
        .outsideTR {
            vertical-align: top;
        }
        .insideTable {
            border: 1px inset black;
            width: 100%
        };
        .insideTR {
            border: 1px solid black;
        }
        .insideTD {
            font-weight: bold;
        }
        th {
            height: 45px;
            font-size: 110%
        }
        .headBck:{background-color: grey};
        tr:nth-child(even){background-color = grey};
    </style>";
let outsideTable := "
    <table class = 'outsidetable'>
        <tr class = 'outsideTR'>" +
    data.("<td>
            <table class='insideTable'>
                <thead>
                    <tr>
                        <th align='center', height='15px'>" +
    date +
    "</th>
                    </tr>
                </thead>
                <tbody>
                " +
    for loop2 in worker do
        "<tr class='insideTR'>
                <td class='insideTD' bgcolor =" +
        ">" +
        loop2.name +
        "</td>
        </tr>"
    end +
    "
            </tbody>
        </table>
    </td>
    ");
"
        </tr>
    </table>
";
html(css + outsideTable)

Here is the code I'm working with. the bgcolor section has been left blank.

putting in

raw(color(loop2.Position))

throws a function not defined error. Thanks for your time!

RoSoft_Steven 

Hey Steven -

Thanks for the suggestion, I also get an error when I do that. I bet it has something to do with the database structure or the loops i'm using, like I've set this entire thing up incorrectly somehow.

Fred Okay, so I had tried that earlier and got another "function not defined" error, which persists even if I copy and paste your code into the block