Dynamic choice field - showing Id instead of description in print view

Maybe this helps: record('Mechanical Services',number('Mechanical Services')).Description

Steven

OK after some trial and error I cane up with this

You are correct. In print view it wants to take the record number but you can update the formula in the print view as shown

Here my dynamic choice table is Colours and the value is Colour

Regards

John

John,

Are you suggesting that the Id must be converted to a number and then assigned to a variable instead of converting it to a number inline like Steven's solution?

No, I realised it can be done inline after I posted. Always the way...

Hello Anna. Did your email to Ninox solve your problem? I've got the same problem, and have not, to date, found a solution.

If you are using the printer icon to get to print layout mode, then you must delete the Dynamic field with the Id and replace it with a Formula field. The structure of the formula is...

record(Dynamic field source table name, number(Field name where the Dynamic field is being used)).Field name in the dynamic source table

Anna doesn't provide the field name of her Dynamic field so that's a guess...

record('Mechanical Services', number(Description)).Whatever her field name is in 'Mechanical Services'

I used both Prints - the icon and the drop down selection. Same result both times - the index number was printed.

I've gone back to FileMaker, which is now working on my Mac M1, so no longer have to work with Ninox, but am still interested in 'playing'. I cotinue to be frustrated when I run into a situation which happens frequently in the real world, but for which no explanation {or even mention) is given by Ninox. I suspect that most people would want to see values, as opposed to indes numbers, on a printed 'report'.

I don't have a dog in this hunt and I wish you well with your relationship with FileMaker. I posted step-by-step instructions on how to print the value of a Choice (dynamic) field and if it didn't work for you that's on you.

I agree the implementation of the new dynamic fields is half-baked, but I like them for what I use them for. I also agree that the lack of communication from anyone at Ninox is frustrating.