How to get a formulae field to show the result of a Dropdown box instead of a number

Ive got a table of staff names

table of scheduling

& a table to show the daily allocation of staff.

table 1: The table of staff names is just so when new staff join and old staff leave, i can simply change this one table.

table 2: table of scheduling is to help the managers see an overall picture of the day and assign the staff is certain areas.

table 3: shows all the information that is needed for a certain area.

Simply i would like it so the managers can use table 2 to plan the day and allocate the staff and the results would be shown in table 3.


When I select a staff name from table 1 in table 2 via a "reference from"

it shows the name of the staff member with a number in front of it.

I then have a formulae field in Table 3 with the following code:

let Datereq := Date;
(select 'Staff Plan')[Date = Datereq].'10am Staff'.

this works except it simply showing the number and not the name.

I can get by this with a 2nd formulae field with if functions but that is not practical if the staff leave or a new staff start.

Is there a way to get the formaule to show the Name.

Ive tried using the 'first' function and 'text()' but with no success.



Content aside

  • 1 yr agoLast active
  • 33Views
  • 1 Following