DavidBRX

Thank you Barry, I'll give this a shot.

Greetings, Is there a way to create some code or method to stamp a record once it's updated with the username who signed-in and updated it? Maybe have it show up on the details data-page as "Last updated by: XXXXX"

Figured it out guys. Thank you much for this most valued and helpful assistance. How on earth you guys know this coding stuff is beyound me, it makes my brain melt! :-) Thank you again, it works like a charm!! % STARS!! Best, David

Thank you both for your time and code. Cooper, I tried yours first and it worked exactly as you show in your sample. Here's the code I entered in the footer. And so, it shows what the status was changed to, which is great. However, if there a way to also show a message with the status confirmation which reads, "Please update the last update date field, and enter a comment in the review section. Thank you." I'm afraid to touch your code for fear of messing it up. :-( <script src="//cdn.jsdelivr.net/npm/sweetalert2@11"></script> <script> document.addEventListener('DataPageReady', notificationHandler) function notificationHandler(){ const statusField = document.getElementById("EditRecordstatus"); statusField.addEventListener("change", function(event) { const statusFieldValue = event.target.value; Swal.fire( '', `Dropdown value changed to: ${statusFieldValue}`, 'info' ); }) document.removeEventListener('DataPageReady', notificationHandler) } </script>

This is awesome guys! Thank you soooooo much. I'll try it this afternoon as I', heading out to the office. I'll keep you posted. Best, David

Greetings all. I'm trying to send a courtesy pop-up notice for uses who change the status of a project by way of the drop-down menu (e.g. Active | Closed | Pending), etc. This notice should pop-up before the record is saved with the new status. I've researched online, and came up with the following (added to the footer of the details data-page), but it's sadly not working :-( ********************************************************************************** ;({var dropdown = document.getElementById("status"); dropdown.addEventListener("change", function() { var popupContent = "Dropdown value changed to: " + dropdown.value; alert(hello); }); ********************************************************************************** Am I missing something? Thanks in advance for your help. David

Hi DrSimi, I just created a localization and added eastern time zone. I also selected all data-pages below so I'll see what happens after 12:00 midnight (fingers crossed). Thanks much for this information. Best, David

Greetings all and Happy New Year!! I'm currently in EST and for some odd reason, my calendar advances to the current date 3hrs behind. Is there a way to remedy this, or is it just this way because their servers are in the west coast? Thanks much all, David

This worked awesomely! Thank you sooooooo much for your expertise and valued assistance. David

Greetings, I discovered the following code on how to format a phone number by placing it in the footer section of a data-page. However, I tried to use this code and tweak it to allow formatting for another field in same data-page where I enter a numeric value like 5654-58-8569. And so, I'm trying to edit this script so I can use if as follows: xxxx-xx-xxxx but can't seem to make it work. So I have two questions if I may: Can I edit the following code to accomplish the above, and ... Can I use both codes separately in the same footer (one for the phone field, the second for the number field as noted) Here's the code I found (which works perfectly for the phone field): <script> var field = 'InsertRecordgpin'; var input = document.querySelector('#' + field); input.maxLength = 14; input.onkeyup = telephize input.onkeydown = telephize function telephize(v_e) { // this.value = this.value.replace( /\D+/g, "" ).replace( /([0-9]{1,3})([0-9]{3})([0-9]{4}$)/gi, "($1) $2-$3" ); //mask numbers (xxx) xxx-xxxx v_e = v_e || window.event; if (v_e.keyCode >= 65 && v_e.keyCode <= 90) { this.value = this.value.substr(0, this.value.length - 1); return false; } else if (v_e.keyCode >= 37 && v_e.keyCode <= 40) { return true; } var v_value = (this.value.replace(/[^\d]/g, '')); if (v_value.length == 7) { this.value = (v_value.substring(0, 3) + "-" + v_value.substring(3, 7)); } else if (v_value.length == 10) { this.value = ("(" + v_value.substring(0, 3) + ") " + v_value.substring(3, 6) + "-" + v_value.substring(6, 10)); }; } document.addEventListener('BeforeFormSubmit', function(e) { if (input.value.length < 14) { e.preventDefault(); alert('Please input a valid phone number'); input.focus(); } }); </script>

I tried, but no so such luck. I'm doing a preview of the added code in the header and footer on a cloned data-page. Not sure if this has anything to do with it. :-(

Is there a way to make this field "auto size" itself based on content entered? If I make the rows to large and only use two roes, it requires huge scrolling within a tiny window frame. If I select 20 rows (as shown) and only enter two rows of data/text, there's a huge open area below. :-( It would e nice to have it expand/contract as content is entered. Not sure if such java code even exists as I've tried searching teh internet with no avail. :-( See attached.

Greetings, It's been a while since this code/tip was posted and it works flawlessly. However, I just recently posted a question and I'm wondering if it's still visible to the author since it was originally posted in January 5, 2022. Does anyone know the answer to the last question I posted on this thread? Thanks much, David

Works flawlessly. Thank you! What if we have multiple conditions same column Say column #2 Yes No Pending Can I change the colors in the same column based on condition?

Hello Tubby, You're absolutely AMAZING! Thank you sooooo much for your time and expertise on this. Ironically, for some odd reason (unknown to me), I removed the # symbol wherever referenced, and this seems to have fixed it. It now calculates all the figures correctly (see attached). Of course I welcome your feedback on why this happened so I can hopefully understand what happened behind the scene when I removed the # from the code. My brain is melting now.