ContributionsMost RecentMost LikesSolutionsLimiting Dashes or Spaces When Entering SSN on Form Hello, I'm looking for a solution that would prevent Users from using "-" or, spaces and making sure they enter 9 digits consecutively in the SSN field. 000-00-0000 = Incorrect 0000000000 = Incorrect 00000000 = Incorrect 000000000 = Correct (9 digits in length, no spaces or dashes) Update: I added formula checkbox as a flag and used the flag inside of a custom data rule to accomplish this. Worked great! ------------------------------ Todd Molino ------------------------------ Re: Creating a sequential numbering order based on Record IDThank you Mark! ------------------------------ Todd Molino ------------------------------ Creating a sequential numbering order based on Record IDHello, I have an Order Acknowledgments table (parent) and a Line Items table (child). Each Line Item is listed in an embedded report on each OA record. Currently, the RID of the Line Item is shown in the embedded report and I'd like to replace it with a sequential numbering system. So instead of the report displaying random record IDs of the items, I'd like the report to show "1" as the first item in the report, "2" as the second etc. These items are the related line items in the relationship to the OA. Any help would be greatly appreciated! ------------------------------ Todd Molino ------------------------------ URL Button - Add Save before using multi-doc upload (Kirk Trachy method)I'm using Kirk's method to upload multiple documents at once and ran into a little problem. The form in which I'm uploading the documents from has a couple of grid edit reports on it for ease of entering data, however everything entered in these grid edit reports are lost if the User then scrolls to upload documents before saving. When using Kirk's method, the record is not saved before the UI opens to upload documents and everything entered in the grid edit reports are then lost. My goal here is to add code in this button to save the record before opening. URLRoot() & "db/"&Dbid() & "?a=dbpage&pagename=MultiDocUpload.html&refFid=6&rid=" & [Record ID#] & "&applicationtoken=cfnbe4ydp5cqspbksxi3nd949xxx" & "&fileattachment=14" & "&categoryFid=12" & "&attachmenttableurl="& URLRoot() &"db/" & [_DBID_DOCUMENTS] Any help would be greatly appreciated! ------------------------------ Todd ------------------------------ Re: Calculating Employee TenureWorks like a charm :) Much appreciated Mark! ------------------------------ Todd Molino ------------------------------ Calculating Employee TenureI have a report that displays each company employee and their tenure based on a hire date. I'd like to amend my formula to show the tenure calculated as of Dec 31st of the prior year versus it being calculated up to the current day of the year. Current Formula: var number Years = Floor(ToDays(Today() - [Original Date of Assignment])/365); var number Remainder =Rem(ToDays(Today() - [Original Date of Assignment]),365); var number Months = Floor($Remainder/30.44); var number CalcDays = Ceil(Rem($Remainder,30.44)); If([Active], ToText($Years) & " Years" & " " & $Months & " Months" & " " & $CalcDays & " Days", If([Role] = "Private Market Agent", "PMA", "")) The "Tenure" displays as such in their record: Thanks for any help with this! Todd ------------------------------ Todd Molino ------------------------------ Rich Text Field - Save Before NavigatingI have a Formula Rich Text button, that when clicked, checks a box that triggers a pipeline and launches a code page while a the pipeline creates child records in two other tables. All of that works fine except for the fact that it will not link the parent to the child records if i select the button in Edit mode. I'm trying to Save the record first and then trigger the pipeline/code page. My formula is below. Hoping someone can offer guidance with the Save Before Navigating portion. Any thoughts would be greatly appreciated! Rich Text Button: var text OGURL = URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" & "&rid=" & [Record ID#] & "&apptoken=dtu36fpy5drric3na9jkc2hufbe" & "&_fid_123=" & URLEncode("true") & "&_fid_151=" & URLEncode("false") & "&_fid_103=" & URLEncode("false") & "&_fid_104=" & URLEncode("false") & "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?act=dr&rid=" & [Record ID#]); var text Refresh = URLRoot() &"db/" & [_DBID_PROJECTS] & "?a=er&rid=" & URLEncode([Next Project Rid]); var text DBPage = "/db/" & Dbid() & "?a=dbpage&pagename=WaitForSalePipeline.html&rid="& [Record ID#]&"&rdrurl="& URLEncode($Refresh); //&"&url="& URLEncode($Action)&"&rdrurl="& URLEncode($Refresh); var text URL = $DBPage; //&"&rdrurl="& URLEncode(URLRoot() &"db/" & [_DBID_PROJECTS] & "?a=dr&rid=" & URLEncode(116)); //$Action & "&rdr=" & URLEncode($DBPage); var text buttonText = "SALE"; var text style = "display: flex;" & "align-items: center;" & "background: #1ba237;" & "border-radius: 3px;" & "padding: 10px 15px;" & "color: White;" & "text-align: center;" & "text-decoration: none;" & "font-size: 13px;" //& "font-weight: Bold;" & "font-style: Normal;" & "display: inline-block;"; If( [Related Customer] < 1, "<div style='display:flex; justify-content:left;'>" & "<a style='"& $style & "' href='"& $url &"'target='_self';><span syle='text-align: left;'></span><span>"& $buttonText &"</span></a>" & "</div>", "" ) ------------------------------ Todd Molino ------------------------------ Re: Clearing a Multiple Choice Field via PipelineJust a quick update on this...It seems to have just been a weird error that was occurring when the pipeline kept rejecting the {{CLEAR}} entry. It works fine today in case others were having the same issue. ------------------------------ Todd Molino ------------------------------ Clearing a Multiple Choice Field via PipelineHi Everyone, I've been able to clear date fields in a pipeline using the {{CLEAR}} option however I'm not clear as to how I would clear a multiple choice field in the Parent table using the update pipe. Using {{CLEAR}} does not work. The pipeline rejects the value when entered for mapping. Thanks for any thoughts on this.... Todd ------------------------------ Todd M ------------------------------ Re: Pipeline - clear date field?Hi Jim, What about clearing a value in a multiple choice field via update pipeline? I'm able to clear dates just fine. Thoughts? Todd ------------------------------ Todd Molino ------------------------------