FINDITEM on Numbered List Without Code
Is it possible to do a FINDITEM on a numbered list without using the code field?
The numbered list restriction exists because I need non-admin end users to easily add to the list (e.g. by adding a 'Create' action).
The code restriction exists because non-admin end users will be adding to the list, and hence will not be able to amend the code.
I realise that a non-numbered list could be used, where non-admin users would be able to add items and amend the code through an import. However the file requirements (file name, column names, column count) seem onerous on the end user and ideally I want to keep things as simple as possible for the end user.
With that in mind I'd like to add some context.
I have two lists:
- Client (numbered). 'Client Name' property, text format.
- Organisation (non-numbered). 'Client' property, client list format.
My organisation structure is, broadly, based off a combination of client and country. Example below:
I would like to map each organisation to a client within the client list. I have created a module that dynamically pulls the client name from the organisation name in text format. I now need to lookup this client text formatted name against the 'Client Name' text property within the client list, and return the corresponding client as a client list item.
Unfortunately, to the best of my knowledge, FINDITEM does not work against properties. I imagine that this is because the property could be duplicated multiple times.
Any help on this would be greatly appreciated!