[JGMcLoughlin]

For Information – here are the version numbers that appear at the top of DFFS:

Attachments:

1. 

   vLookup4.png
   

[JGMcLoughlin]

Alexander,

Sorry if I am going off on the direction. Here is what I have done following your last message:

I copied the following files from the Oct 6 download to a folder called JQuery of the site I am working on (this is the original location of the files from the date of installation). Those files already exist in the DFFS directory.

I am still using the inline CEWP method of connected, rather than the in-list column method. Should I try that?

Incidentally when I do as suggested I lose a number of tabs from the form – they are still defined, but not visible. DO I need to change the rules?

I still get the same result, except this time I am getting nagged about a trial licence having expired – see attached.

John

Attachments:

1. 

   vLookup3.png
   

[JGMcLoughlin]

Here is an update. I just went into the dispform and found the following:

1. The console popped up an error (see attachment)
2. The vLookups were working!!

Attachments:

1. 

   vLookup2.png
   

[JGMcLoughlin]

Hi Alexander,

I have taken the DFFS back to v4.035 for that list – using the CEWP method, and the vLookups are still not working. I have gone to the Console and there are no errors showing up.

Is there anything else I can look at?

John

[JGMcLoughlin]

Kris,

You are correct in thinking of the ID in the SharePoint list. Would make life difficult for you. How about my other idea?

John

[JGMcLoughlin]

Kris,

I was thinking of the unique ID that each record in a list has. It is usually hidden, but can be made available. The only time you can’t use it is when creating a record as the ID is only assigned once the record is saved. This may cause problems as you have no control over the number.

You could do something with the first option, by creating a third, calculated field which creates a composite of the question number and the question, e.g.

Q No    Question                         Composite
1.      What colour is the sky?          1. What colour is the sky?

Just a thought.

John

• This reply was modified 9 years, 5 months ago by JGMcLoughlin.

[JGMcLoughlin]

Kris,

Could you use the ID field? This would give you a number unique to the question. A danger would be that the questions would have to be entered in the correct order.

OR
Introduce another column for the Question Number, and show that ahead of the question on the form.

John

[JGMcLoughlin]

Drew,

Have you tried using rules to achieve what you want? You can set a field to being required in a rule, so this might work. I have just spent days trying to do something clever in JavaScript only to discover I could have used a series of rules to achieve the same ends.

[Author]

Posts