Hi
I have Costcenters list and user entering data for one cost center in a dashboard and user wants to copy same data to other cost center
How to do give such option to user in dashboards?
Thanks
Tejaswini
We'd definitely need more information, screenshot and blue print of the module would help, but to answer in general terms.
> [EASY] Copy Across/Copy Down: Requires Cost Center to be on either rows or columns. You'd have to teach the user to 1) Right Click-"Show" pertinent Cost Center (copy-from CC and Copy-to CC's), 2) Highlight cells to be copied, and 3) Edit > Copy Across/Copy Down
> [EASY] Classic Control C-Control V: limited of course by number of cells.
> [Effortful] Create a Copy action. Have user input line items to drop down both the copy-from Cost Center and copy-to Cost Center. Prepare a saved view filtering the copy-from Cost Center information, plus the line item with the copy-to Cost Center. Create an import from this saved view to the Input Module.
> [Business Process Improvement] Consider creating profiles with the information needed (same input line items as the input module), but on a different list that is not cost center. Users can then map a Cost Center to a profile and information can be looked-up from the profile
Hi @rolympia
Please find the attachment.
I have Cost centers list on rows and Accounts list on columns.So for one costcenter , selecting driver for each account and need to copy the same data to remaining Costcenters.
Is there any way other than Ctrl C ,Ctrl V?
Hi @tejaswini ,
You can try below approach:
1. Create one system module for the selection of Cost center
2. Create one more without Cost center dimension & other dimension with be same as your input module.
Write a formula pointing to your Input module, here
INP_Cost Center by Account.SKF Selection[LOOKUP: SYS_ Selection.Cost Center Selection]
3. Create a new module which is same as your input module and write a formula pointing to step 2 module.
Now this is your formula driven module, here I have create one save view to import the data to our Input module by applying one filter cost center <> sys_selection->cost center (even not required, it will override the same data)
4. Create an Import action to transfer the same data to input module.
After import:
Note: This approach will depend on the size of your input module because we are duplicating one module.
Hope this helps
Akhtar
I think Akhtar's solution would be the best path forward.Creating the system module for costcenter selection and using the import functionality should work great.
Hi, I am working on a solution where the User should only have access to write/edit the list members that they add from an Action on the frontend. This action adds another list member to a selective access list. The problem is, in order to run the action, you need access to the entire list, so you would see all list…
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?
