Home › Forums › vLooup for SharePoint › vLookup Refresh New
Tagged: vLookup Refresh
- This topic has 12 replies, 2 voices, and was last updated 4 years, 1 month ago by Alexander Bautz.
-
AuthorPosts
-
-
September 2, 2020 at 20:22 #31463
Hi Alexander,
I’m having issues with the vlookup on New Form.
My connection is set up right because it loads correctly when the form loads, But If try to refresh OR add a new item nothing happens and the loading icon just keeps going and going, never resolving.
Any help would be greatly appreciated.
Attachments:
-
September 3, 2020 at 16:20 #31472
Which version of vLookup are you running? – I think this is a bug that is already fixed some time ago.
Alexander
-
September 3, 2020 at 16:21 #31474
Also, please include a screenshot of your configuration for this vLookup field.
Alexander
-
September 3, 2020 at 16:38 #31480
I’m on June 28 and I looked thought the Change log but didn’t see anything calling it out.
Let me know if I missed something and should update.
Attachments:
-
September 3, 2020 at 22:38 #31483
No, the version I thought about was over a year old.
Can you try hitting F12 in to bring up the developer tools in the browser and then click the Console tab before you try to refresh the vLookup table – any error messages in the console?
Also, a screenshot of the vLookup config might give me some clues.
Alexander
-
September 4, 2020 at 14:31 #31485
Attached is the console before the refresh. There was no change after the refresh.
I also tried to call the refresh manually.
When I tried to Refresh with the Debug open I noticed that the debug details never change, on the edit from it added details at the bottom showing the refreshed work .
Let me know what you think.
Attachments:
-
September 4, 2020 at 15:35 #31491
I need to see a screenshot of the vLookup config tab in your DFFS backend – the query part and the ViewFields part of this specific field.
Alexander
-
September 4, 2020 at 15:40 #31493
Here you go.
Attachments:
-
September 4, 2020 at 17:40 #31502
I would note that I have changed the vLookup connections a number of time with no change. I originally had it set up with the _vLookupID and _vLookupPurchaseID and I also did Title Equals Title.
All of them worked fine in Edit. This what just the last thing I tried.
Let me know if you need anything else.
-
September 6, 2020 at 08:46 #31511
I looked at the error messages again and it shows that your custom js function vLookupIsLoadedCallback (in your parent form NewForm) is the origin if the error.
Please post your function here so I can look at it.
Alexander
-
September 8, 2020 at 14:27 #31516
Hi Alexander,
I looked into the vLookupIsLoadedCallback and It seems that it works fine unti spjs.dffs.data.thisItemID
Any ideas why this would return as an empty string in the new form?
I was using the functions from a previous post to Total and set a field.
function vLookupIsLoadedCallback(fin){ if(fin === "vLookupItems"){ //Get Total from vLookup ceiling, if not active dont run at all var vLookupTotal1 = spjs.vLookup.dataObj["vLookupItems"][spjs.dffs.data.thisItemID].tot["Cost"]; setFieldValue('TotalCost',translateNumberToCurrency(vLookupTotal1)); }}
Attachments:
-
September 8, 2020 at 15:23 #31519
Hi Alexander,
Found it. Just took more digging on your blog to go back to 2018.
On the new form, have to use:
spjs.vLookup.dataObj.vLookupItems[getFieldValue(“_vLookupID”)].tot
OR
spjs.vLookup.dataObj[fin][getFieldValue(“_vLookupID”)].tothttps://spjsblog.com/forums/topic/totals-row/
Since this is preventing the vLookup from refreshing, on new, will there be plan for a patch?
Or since its our choice to use the custom callback code, we just need to be aware that we need two different things for new and edit.Thanks for All the help!
-
September 8, 2020 at 16:08 #31521
I’m glad you figured it out. Unfortunately I cannot patch this because it – as you mentioned – is in custom js and I don’t really have any control over the use of variables there.
The reason for not being able to use spjs.dffs.data.thisItemID in NewFrom is that there are no ID for the current item until you have actually saved it to the list.
Alexander
-
-
AuthorPosts
- You must be logged in to reply to this topic.