Best method of auto filling

[Roo]

I am very new to your SFD program and have found it a delight to use.

I'm trying to auto fill the current user name and Current date into the user and date fields when they tick a checkbox.

signoff.jpg (82.31 KiB) Viewed 1631 times

[Nikita Kurguzov]

Hello, Roo!
You can try code like this:

Code: Select all

fd.field('Checkbox').change(function(){
	if(fd.field('Checkbox').value()){
	  	fd.field('By').value(_spPageContextInfo.userLoginName);
		fd.field('Date').value(new Date());
	}
	else{
		fd.field('By').value(null);
		fd.field('Date').value(null);
	}
});

Change field names to internal names of your fields and it should work.

[Roo]

Thanks for your quick reply.

I've put this code into my form, but with success (I have substituted the internal names)

The field that I am looking to update are user and date fields - Will that cause issues?

I will carry on trying and never give up

[Roo]

It did work - Thanks Nikita.

I set the two name and date fields as read only as I didn't want users to change things!!

Once I made the fields writable it was ok.

I guess I could do this in the code?

[Nikita Kurguzov]

I guess I could do this in the code?

Yeah, exactly, it would be better to do it in the code. Make them readonly when you open the form, then set readonly to false prior to changing values and back to true once new values are set.

Something like this should work:

Code: Select all

fd.field('Title').readonly(true);

fd.field('Checkbox').change(function(){
	fd.field('Title').readonly(false);
	
	if(fd.field('Checkbox').value()){
		fd.field('Title').value('New Title');
	}
	else{
		fd.field('Title').value(null);
	}
	
	fd.field('Title').readonly(true);
});

[Nikita Kurguzov]

One last thing, you also need to have all fields set to Readonly:false when you save an item, otherwise these values won't save correctly.

So, add something like this in the end of JavaScript editor:

Code: Select all

fd.onsubmit(function(){
  fd.field('By').readonly(false);
  fd.field('Date').readonly(false);
  return true;
});

[Roo]

Awesome. Works exactly how I needed it.

Thanks Nikita.