Bringing in Roles - Formula Help

tspoon

Hi -

I am trying to bring in Role. I added them as a line item in my module:

Screen Shot 2022-03-16 at 3.53.39 AM.png

Here are all the modules:

And here are my lists:

There is a dropdown for me to manually put in the roles, but I just don't know what to do for the formula.

Screen Shot 2022-03-16 at 3.53.54 AM.png

Can anyone please help me with how to write a formula to bring in Role?

Accepted answers

All comments

M.Kierepka

Hi,
I am not sure what are you trying to do - what does "bring in Role" mean?

tspoon

Hi @M.Kierepka

So there is a list called 'Roles':

Screen Shot 2022-03-16 at 10.38.30 PM.png

And they need to be assigned to people via this module (here is the grid view):

Screen Shot 2022-03-16 at 3.53.39 AM.png

You can see in regular view that choices are already there as a drop down but I need them automatically populated:

Screen Shot 2022-03-16 at 3.53.54 AM.png

Any ideas on a formula to do this?

aakash

Hi,

From your question, it is understandable that roles are to be assigned to users. To determine the formula, please first describe the logic on how a role should be decided for a particular user. If you're trying to bring in native 'User Roles' to a line item , that won't be possible.

Anyone would be better aligned to help you once you describe the exact logic you require

Regards,
Aakash Sachdeva

MarkWarren

This would normally be imported if this data is known. Otherwise you'd have to have some relation of Role to one of the other properties of an Employee, but its unlikely that the Roles here would be defined by Country or Department for example.

Misbah

@tspoon

As far as I know you need to Import the data into the module. Roles must also be available in the source file, all you have to do is to map the Roles from Source to the Roles from Anaplan. You have already imported Name, Country and other fields, similarly Roles also need to be imported.

Not sure how and why was this missed in the import action that you might have run earlier. It should have been auto mapped. Anyway just go to the "Action" and hit "Edit" option and map this line as well and run the import again

Hope that helps

Misbah

MIZ LOGIX

Quick Links

Can you help?

Unanswered questions

Different Subsets of Parent Lists in Input & Output Modules
I have 2 lists used in modelling, In Input module I'm using subset of territories from Country List and subset of Regions from Flat list. But in Output module,Its reversed, I'm using subset of regions from Country list and subset of territories from flat list.How to derive the numbers from input to output module. I do have…
Is there a way to turn off the Show Comments Summary panel in UX pages with Comments?
This shows all comments across all data to all users with access to the UX page. This is not appropriate for any UX which might contain security access sensitive data. Comments on grids and cards ARE security dependent. That works fine. But anyone with access to the page can open this Summary Panel and see ALL comments…
Are there any plans to support actions to rename or delete native Versions?
If anyone is aware of idea exchange ideas that are currently being evaluated by the product team, if you don't mind linking them here, would love to give them an upvote. Thanks!