I have a rollup field that shows the last order for a particular sku. I’d like to link to this record.
I can link to all orders for this SKU as you can see with the linked Daily Orders field and this would be fine if it showed the latest order first but it doesn’t.
Anyhow, because the order number is a text value, I first convert it to a number so that I can use max(value) in the rollup field and then I convert it back to it’s text form:-
I’d like to link to this record but I can’t find an automated way to do this.
Once my Latest OrdNum formula field is populated I know I can change the field type to lookup and it will work, but only for the records that there at the moment.
Any ideas on how this could be solved please.