Ability to use Additional Fields from a Lookup Field
Original Post by Sean Docherty (Imported from Ardevia Forum)
Hello,
Recently I was working with three SharePoint lists, Orders, Purchases, Bill To.
I wanted to add the fields from the Build To list to the Orders list.
I selected the Bill To Company and wanted to add the additional fields that are associated the Bill To Company Name, such as address, city, country etc.
When you check off the additional fields, they show up in the SharePoint list as Bill To:Address, Bill To:City, Bill To:Country, etc.
When you try to add these fields to the Ardevia form that you are creating they do not show up in the Field list from the Field option in the ribbon of the Ardevia product.
Is there a way to use these fields within the Ardevia forms product? Having the ability to use these fields in your form would be a great feature to have as it would populate information in other fields based on the selection of the primary field.
Would having the ability to use these additional fields also not solve the issue of Cascading fields? In my opinion, if you could work this into your product it would be amazing!
Thank you
-
Original Post by Vitaliy Zadorozhnyy (Imported from Ardevia Forum)
Hello Sean,
Regarding additional fields to lookup column:
These fields are read-only in SharePoint and are not displayed even on the default(out-of-box) edit and new forms. They can only be visible on display form. For the moment you can use just normal text fields in display mode and implement expression to populate them based on lookup field change. For this you can use GetFirstValueForQuery context expression :Code:
[[@Web.GetFirstValueForQuery('ListName or relative Url', 'Caml query', 'FieldName')]]
Some Idea how to implement this you can get from thispost. I know it is regarding sublists but the similar expressions should be for form fields.Regarding cascading lookups:
Yes we will develop this feature in future.0
Please sign in to leave a comment.
Comments
1 comment