Get Lookup value of another column
Posted by jcmeyer - Jul 7 ’14 at 03:30
I have a list with 3 columns:
FileNumber, ContactPerson, City
FIleNumber is unique
In another list I have a lookup column on 'FileNumber'. I want to pass the value of column ('City') to a variable after selecting the associated FileNumber. I will then set the value of City in the new form automatically onChange to FileNumber lookup.
I can get the record ID of the lookup using fd.field('Lookup').value
I can get the text of the lookup (FileNumber) using fd.field('Lookup').control('getSelectedText');
Is there any way I can get the text of City after selecting a FileNumber in the lookup?
Thank you
-
Dmitry KozlovAdminMember for: 9 years 8 months 7 days
Hi,
Unfortunately, you cannot retrieve additional columns of a lookup value dynamically. But you can try our Cross-site Lookup column that allows to request additional column and save them into a hash-table inside the 'Item format' function. Next you can get all these columns by the selected key value on a form via JavaScript.
-
jcmeyerMemberMember for: 8 years 10 months 21 days
as an alternative I can return additional columns with the standard sharepoint lookup and display the additional columns in another form. The user must select the related item from a lookup dropdown and submit to see the changes.
I have tried adding a button with the following onclick event as described in another forum post, but it does not seem to be working; basically I want to submit the form but not close the form (New or Edit form).
fd.sourceFormParam(decodeURIComponent(window.location.href));
return true;Is there anything else I need to add to the onclick event to submit and return to the same form? or, any way to show the values of the additional lookup columns once the primary lookup dropdown is selected?
thank you very much.
-
Dmitry KozlovAdminMember for: 9 years 8 months 7 days
[#2]: Hi,
Please, read the following post to get information on how to redirect users to the edit form right after creation of an item:
http://formsdesigner.blogspot.com/2013/10/how-to-open-edit-form-right-after.htmlWith regard to the edit form, you can place a new save button in addition to the existing ones called 'Save without closing' and put the following code into its OnClick handler:
fd.sourceFormParam(decodeURIComponent(window.location.href)); return true;
More info:
http://formsdesigner.blogspot.com/2013/12/customization-of-toolbar-buttons-and.htmlIf it doesn't work for you, please, send HTML-source of your form page to [email protected].
-
seoexpertMemberMember for: 8 months 4 days
Thanks for the best blog. it was very useful for me.keep sharing such ideas in the future as well. brown minimalist art
-
seoexpertMemberMember for: 8 months 4 days
A debt of gratitude is in order for the blog entry amigo! Keep them coming... pencil packing job
-
seoexpertMemberMember for: 8 months 4 days
This is just another well executed post on the site. I have enjoyed reading the content on understanding-amended-tax-returns-and-electronic-signatures. It was worth checking out.
-
RamonMilesMemberMember for: 5 months 7 days
The event management companies is rapidly evolving, and we can expect several trends to shape the industry in the next five years. Firstly, there will be a greater emphasis on sustainability and eco-friendliness in event planning. Secondly, virtual and hybrid events will continue to gain popularity, with new technologies and platforms enabling more immersive experiences. Lastly, there will be an increased focus on personalization and creating unique experiences that cater to individual attendees' preferences and needs.
-
seoexpertMemberMember for: 8 months 4 days
Tips are much necessary to promote businesses and they should be learnt before hand. Organizations such as www.airslate.com/product/drag-drop-flow-creator provides a platform where people can give reviews. This creates an image of company in the eyes of potential customers
-
seoexpertMemberMember for: 8 months 4 days
A debt of gratitude is in order for the blog entry amigo! Keep them coming... Immobilien Andervenne
-
Ravina20MemberMember for: 18 days
Thane Escort Service|| Wardha Escort Service|| Washim Escort Service|| Yavatmal Escort Service|| Aurangabad Escorts|| Achalpur-Escorts||" > || Aheri-Escorts|| Ahmadnagar-Escorts|| Ahmadpur-Escorts|| Airoli Escorts|| Ajra Escorts|| Akkalkot-Escorts|| Akkalkuwa-Escorts|| Akola-Escorts|| Akot-Escorts|| Akrani-Escorts|| Alibag-Escorts|| Amalner-Escorts||
Show more messages