Version History, Issues with Rich Text, and other notes

[Travis Goodman]

Hey Alex!

Just loaded the latest version of DFFS. One thing that is needed, restore previous version from version history. When I look at the version history of an item, I like that I can see everything, but I don’t see the button to restore a previous version.

For multiline rich text fields, when a picture is entered into the field, it doesn’t retain. I haven’t tested this in 0.72 yet, but every time I made a note and I wanted to include an image, the image would paste, but then when I save and go back in, it’s lost and gives the thumbnail of a broken image icon. Can you let me know if you have the same user experience?

Is cascading dropdowns plugin coming soon? Something I have come across in classic DFFS and will want to have it in modern DFFS, sometimes in limited situations there will be no value for a cascading dropdown option in the middle of the cascading “tree”. What I’ve come up with is in CustomJS I’ll load dataSourceArray and call spjs.casc manually. I will then do an IF statement where IF [field] === null then set that value in the dataSourceArray to None. I’m doing this before I ever call spjs.casc so that when I call it, those fields have a value and my cascading dropdown doesn’t break. It happens sometimes in certain situations.

Here’s one for example: I have a cascading dropdown of employees. I go Employee > Manager > Area Manager > Director. Sometimes there is no manager, so it may jump straight from Manager to Director. Regular cascading dropdowns would result in a break here, and no Director would ever get set. My method above replaces the null with the option of None, and that fixes it. Something to think about.

I also know I owe you some additional information on previous posts, I will get that for you hopefully soon.

[Travis Goodman]

Found another issue this morning. On vLookup build a table, I was just notified by a user in a timezone that is 1 hours behind my own (I’m in Central Time United States, they are in Mountain Time United States). I am bringing a date field into the table for the vLookup. For me, the dates look correct. For the coworker in the other time zone, the dates are off by -1. If that same user goes to the list referenced in the vLookup and looks at the date values in the list, the dates show correctly for them. The issue is exclusively in the vLookup table.

[Travis Goodman]

So I found the underlying problem, and it’s daylight savings time. The way that date field is brought in, is not respecting daylight savings time.

[Travis Goodman]

I solved for the timezone issue by adding a Customizer function to the field in the vlookup table.

function vLookupDateFormat(item, field, config) {
if (item[field.fin] !== null) {
var d = new Date(item[field.fin]);
return new Date(d.getTime() + 6 * 60 * 60 * 1000).toLocaleDateString(); //the + 6 (hours to add) * 60 * 60 * 1000 fixes an issue with the dates not displaying correctly for anyone not in Central Time due to DST. Note that this will change the timestamp, but I don’t care about the timestamp as I only show the date value.
}
}

However, I recreated a previous issue I reported with vLookup in Modern DFFS I’d like you to look at.

In the build table section, I had the customizer function before and I removed it. Saved the form and then looked at the item and it said “Customizer Function Not Found” but I had no value in the Customizer Function section for that field in the vLookup configuration. I couldn’t get that error to go away, so my only choice was to remove the field from the build table config and re-add it. When I did that, I saved the form, and the error went away. However, when I went back into the vLookup config, and I went to the “Add new item” section, all of the Prefill field values I had set completely changed. It was using the same fields from the Build the Table tab, and I don’t use any of those fields.

Build table tab has:
Title
StartDate
EndDate
Status

Add new item tab has:
vLookupProjectID (single line of text) that I set to [[fieldValue:_DFFSID]]
ProjectLookup (lookup column in child list) this I set to [[item:id]]

When I removed StartDate and EndDate from Build table tab, and I readded them, I saved. Then I got a report of someone trying to add a new item where ProjectLookup and vLookupProjectID were not getting set automatically. So I go into the config and I see that the Add new item tab was completely changed. It showed the same fields as the Build Table tab. This has happened several times.

[Alexander Bautz]

Restoring a previous version is not currently possible using client side code, but there is an option in the Misc tab to show a link to open the default version log functionality where you can restore a previous version.

Pasting images is unfortunately not supported (as it is also not in standard SharePoint). The paste functionality is there by default in the browser, but when you paste in a rich text field, the image uses base64 formatting that SharePoint just removes when you save it. The only way to add images is to use the URL to an image in the add-image icon.

I’ll look into adding support for automatically saving pasted images as attachments (or add them to siteassets) in a future version.

Cascading dropdowns are already supported – look at the user manual for details.

Regarding vLookup dates: Does the date show correctly in the child item if the user opens it up and not just looks at it in the vLookup table in the parent item?

Regarding customizer function: I have fixed the bug where removing the customizer function shows the message “Customizer function not found” in the upcoming version.

I’m unfortunately still not able to recreate the issue you describe with all viewFields from the Build the table shows in the Add new item tab. Are you maybe copying or cloning the vLookup config prior to this happening?

[Travis Goodman]

> Cascading dropdowns are already supported – look at the user manual for details.

I apologize! I didn’t fully review the documentation; I expected to see it as a tab module like in Classic. My bad!

> I’m unfortunately still not able to recreate the issue you describe with all viewFields from the Build the table shows in the Add new item tab. Are you maybe copying or cloning the vLookup config prior to this happening?

No, here is the situation and the exact way I get it to happen:

1 – create your vLookup config and set it up as normal. Have the “build the table” filled out and with your date field do a customizer function that uses the function I posted above, and then have the “Add new item” setup with the prefill fields. For me, I had a child list with vLookupProjectID (single line of text) and ProjectLookup (lookup column in child list). I would set vLookupProjectID to [[fieldValue:_DFFSID]] and I would set ProjectLookup to [[item:id]]

2 – everything should work normally right now. You should see your table and you should be able to add a new item with the prefilled values properly.

3 – go into the vLookup config, and remove the customizer function

4 – you should now get an error “Customizer function not found” when you go into the item and view the vLookup table

5 – go back into vLookup config, and the only thing you can do is delete the field from the table and re-add it to get rid of that error.

6 – go look at the table, things should look normally again, but now click on add new item… is your pre-fill values still working? Mine don’t.

7 – go back into vLookup config, and you should see that the pre-fill values section is totally different and missing the pre-fill references.

That’s the best way I can explain it.

—

## Another new request if possible for a future release ## – would it be possible in a rich text field or maybe in a custom drag/drop element where we can have a checklist functionality? Like what you often see in OneNote. I’m creating a project tracker app, and it’d be awesome if I could dynamically add checklists into a rich text field so I can allow my team members to simply check the box when that action has been completed. Refer to OneNote and see the “To Do” checkbox for the functionality I’m asking for.

[Alexander Bautz]

The deletion of the viewfield was the clue – I had a cross reference between viewfields and prefill fields when deleting fields. I have fixed it in the upcoming release, but this will not be published until sometime this weekend.

I have noted your other request (to-do-list) and will look into it later. I assume the status of the to-do items will only “live” inside the individual list items and not be rolled up in any kind of way? (that would complicate things).

Alexander

[Travis Goodman]

Awesome! Yeah for the to-do list, I really only need it to be a visual thing, not an actual SP field or anything like that. I plan to use it as a visual reminder for my Project Management team to easily track and make sure they’ve done x,y,z and they can check off once they’ve done it.

[Author]

Posts