vLookup on Calendar list

This topic has 9 replies, 2 voices, and was last updated 4 years, 10 months ago by Alexander Bautz.

Viewing 9 reply threads

Author

Posts
- February 4, 2020 at 18:39 #28497
  Jay Baldwin
  Participant
  Hello Alexander – Does vLookup to a calendar list require any special setup?
  
  The ‘add new item’ button appears on the parent Edit form and launches the child calendar list new form as expected. The new item is created in the child list. However, the prefill values are not saved. Do I need to do anything special with a calendar or picture library?
  
  Thank you!
  
  Jay
- February 4, 2020 at 23:23 #28499
  Alexander Bautz
  Keymaster
  You must have DFFS installed in this form, and you must save the config for the form (it doesn’t need to have any configuration, but it must be saved).
  
  Does it make any difference?
  
  Alexander
- February 4, 2020 at 23:48 #28501
  Jay Baldwin
  Participant
  DFFS_Installer.aspx shows status = Installed for all three forms for the Calendar
  I confirmed there is a configuration saved for the forms
  
  It is not working.
  
  Using v4.4.4.17 – December 19, 2019|CSS version: 4.48 / 4.48|spjs-utility version: 1.342
- February 5, 2020 at 11:06 #28503
  Alexander Bautz
  Keymaster
  In the top right corner (over the Delete button) you see a “Last saved” timestamp – is it showing a timestamp, or is it empty?
  
  Alexander
- February 5, 2020 at 15:50 #28507
  Jay Baldwin
  Participant
  Yes, there are timestamps:
  
  The child form (/lists/reportdeliverablescalendar/newform.aspx) Last saved: Tuesday, February 4, 2020 4:45:01 PM
  
  The parent form (/lists/reportdeliverables/editform.aspx) Last saved: Tuesday, February 4, 2020 11:36:10 AM
  
  Jay
- February 5, 2020 at 17:05 #28513
  Alexander Bautz
  Keymaster
  OK, then I will need some screenshots of your vLookup config and of your NewForm in your Calendar list (when you have clicked the New item button in vLookup).
  
  For me to see it you must have the fields you try to fill visible in the form.
  
  Alexander
- February 5, 2020 at 18:59 #28525
  Jay Baldwin
  Participant
  Let’s try again!
  Attachments:
  
  vLookup-Configuration-Parent.docx
  
  vLookup-Configuration-Child.docx
- February 5, 2020 at 19:48 #28532
  Alexander Bautz
  Keymaster
  The field _vLookupParentID is not showing in the NewForm and my guess is that it has not been added to the content type your form currently uses. Go into list settings, click the content type and add _vLookupParentID.
  
  Alexander
- February 5, 2020 at 20:14 #28536
  Jay Baldwin
  Participant
  That worked! The OOTB SharePoint calendar list uses the Event content type. Thank you, Alexander!
- February 5, 2020 at 23:01 #28544
  Alexander Bautz
  Keymaster
  I’m glad we were able to figure it out – and thank you for your donation!
  
  Best regards,
  Alexander
Author

Posts