Forum Discussion
Ganesh1020
Feb 28, 2019Copper Contributor
Lookup Columns to make visible in form while creating new item
Hi,
Is it possible to make visible the lookup columns when we create new item in sharepoint before saving this new item.
For example, I have 2 site pages as Customer List. Site A and Site B.
In Site A (which is Master Data), i have all the information about employees like Employee name, Supervisor Name, Dept, Emp Code etc.
In Site B, i have added one column Employee Name where i will use Lookup to get the details of employee from Site A. So once i fill employee name, it gives other details also for that employee based on Site A
Lookup is working very fine.
But here issue is, when i create new item in Site B, the form does not display those Lookup columns coming from Site A. I can see the "Employee name" Column. Only when i save the item, those lookup columns coming from Site A are getting displayed in Site B.
Is it possible by JavaScript or by any other means, whether i can display those columns also while creating New Item in Site B. So once i fill "Employee name", automatically in same time, it will display those lookup columns data coming from Site A before saving the New item.
Like in Excel sheet, if there is any vlookup formula, and i will input data in col A, then immediately i can see the Output data in Col B. Same display function, i need to fix in Sharepoint page too before saving the new item.
Please help
Thanks
- Eva VogelSteel ContributorHi! I guess you should create a global valid column In your sites.
Go to the top level site. Create a new site column. If it’s already your office 365 users, create a sit column type „Person or Group“. So you can place your site column into all other sites after that. I would advice you to work with groups of persons, not with single users. So each one will see the relevant groups of team working in your forms. Hope that helps. Greets, Eva- Ganesh1020Copper ContributorHi Eva,
Thanks for your response.. Actually is more than 5000 rows and lookup columns are 5 count.. Actually I didn't get about how person or group option will work to make visible those lookup columns before submitting the request..
Thanks
- Ganesh1020Copper ContributorWhether there is no expert who can help to resolve this issue...