I just made a first update to a v2 SharePoint form I had created with the V3 editor, and it removed the formatting I had on numbers (using a number field to capture phone numbers) and re-added commas to the field.
In the new designer, how do I format number fields to remove commas?
Hi @Gabe_Giacomo,
Try using the Masked input field with this mask: (000) 000-00000
Make sure to assign the value of the masked input to the number field before saving the form like this:
fd.spBeforeSave(() => {
fd.field('Number').value = parseInt(fd.field('MaskedInput').value.replace(/\D/g, ''));
});
1 Like
Resurrecting this for a bit - that worked fine, but I have 4 different phone number to keep track of in this method.
Is the ability to format to hide columns in the SharePoint forms in the development pipeline, and if so when is the expected release date?
Thanks for the solution!
Dear @Gabe_Giacomo,
Can you clarify what you mean? It's possible to hide columns/fields with JavaScript at the moment, non-JS version is in pipeline.
Or is there something specific you're looking for?
Hey Nikita -
in V2 of plumsail forms designer, I could format a SharePoint online number field to hide all commas (similar to out of box SharePoint online). In V3 (per this thread) I'm adding in a separate masked field and writing it back to the SharePoint field on save. Being able to just mask the Number type SPO field in the form designer would save some javascript code and another field.
Just a request/recommendation.