Fields by Site Column lookup - How to show additional fields with Site Column Lookup?
Original Post by Kaoru (Imported from Ardevia Forum)
Hi, is there any easy way to show fields added by lookup?
Additionally the lookup is not in the same site, but in parent SharePoint site, which is referred using [b]Site Column[/b], added by "Add from existing site columns"
as shown in the image above, I'd like to show "ProjectName", looked up from Project List in the parent site, matching with "Project Number".
Rich Forms does not show such fields under "Field".
(The field is read only by its nature. But SharePoint list shows these fields too, so our client expect that.)
A last resort would be -- writing code with REST api. if you already have sample of jQuery code for Initial value in Behavior section somewhere, that helps me...
--- b.t.w. the support by Vitaliy, Ardevia developer, this morning was really excellent. Thank you!
-
Original Post by dany (Imported from Ardevia Forum)
Readonly fields are only available on the display form, not on the New and Edit forms.
Actually this is the same as on SharePoint standard forms. This also applies for example for SharePoint calculated columnns. I assume the main reason Microsoft implemented it like this is that these fields are not automatically updated in the form when the lookup is changed. This would confuse users.An alternative using Rich Forms is to add columns to the list and use calculated value expressions like [[Lookup.SomeField]] to dynamically set these fields when the Lookup column is changed. This would make the field automatically show the updated value in the form when editing the Lookup.
0 -
Original Post by Kaoru (Imported from Ardevia Forum)
Yes I have been working how to set the calculated value. Where can I see the manual/sample about the usage of "Lookup"?
0 -
Original Post by dany (Imported from Ardevia Forum)
In the documentation there is some information on the available placeholders: skybow SharePoint Apps
In the expression builder you will also find a tree to the left with possible placeholders. If you expand the appropriate lookup field the possible fields of the list are shown. Double-clicking on the field you want will insert the placeholder in to the expression.0
Please sign in to leave a comment.
Comments
3 comments