ClaytonRountree
Qrew Cadet
Joined 6 years ago
User Profile
User Widgets
Contributions
How do I get an Automation Action to apply a timestamp to a Date/Time field for the moment the Action occurs?
I have an Automation that is designed to create children records on a related table. I'd like those children records to be timestamped with when they are created. When I add an Action to the Automation for the Date/Time field [Timestamp], and put "Today()" in the field, it does not populate when the Automation is triggered. I feel like this should be a pretty simple one, but I haven't been able to figure it out. Thanks!4Views1like3CommentsRequired Field Desired on Initial Record Creation, but not on subsequent edits
I have a few multi-line text fields (tracking history) that when creating a new record in the table I want to be required. But after initial creation, there may be subsequent edits to the record. For these subsequent edits, I don't want all required fields to require updates (specifically the tracking history ones are requiring me to update them, even if I have nothing to add). For example...say I update the date on a record...should I also have to update the comments box, if I don't want to? It seems there should be a way to only require the field on initial record creation...is this possible? Thanks!Populating a Lookup field with Formula URL button
Hi, I have 3 tables involved in this issue. Parent: Estimates, Child: Estimate Details, and a related Table "Teams". I have a button that creates several children records on Estimate Details. The button sits on Estimates. The children records have certain fields that I pre-populate (assign) values to in the button code, like adding a timestamp, and labeling the status as TBD. Teams is related to Estimate Details, each team can have many estimate details. Previously, the button would also assign a team name, using the text of the team name. This was sent to a Multiple Choice Text Field. I've tried to update my DB structure, so that we host the list of Teams on its own table. Thus, I'd like to populate the children on Estimate Details with the corresponding team name from the Teams table. Sample Code: var text AddCEmailServices= URLRoot() & "db/" & [_DBID_Estimate_Detail] & "?act=API_AddRecord&_fid_41=" & URLEncode ([Record ID#]) & "&_fid_49=" & "Commercial - Email Services" & "&_fid_40=" & "TBD" & "&_fid_89=" & Now() & "&disprec=1"; and later: "javascript:" & "$.get('" & $AddCEmailServices & "').then(function(){" & ... "});" & "void(0);" The bold italic line is what I'm hoping to change. The field that links from Teams table is fid_100 for [Related Team] (Record ID) and the proxy [Team Name] is the team name fid_101. I've tried replacing that line above with & "&_fid_100=" & URLEncode ("5") as well as: & "&_fid_101=" & "Commercial - Email Services" These have not worked. Please let me know if you have any suggestions. Thanks!Formula URL Redirect in Javascript
I'm interested in modifying the javascript below to include a location redirect in the script. //code for the redirect var var text DisplayRecord= URLRoot() & "db/" & [_DBID_TASKS_POC] & "?a=td"; //execution section "javascript:" & "$.get('" & $AddRecordOne & "').then(function(){" & "$.get('" & $AddRecordTwo & "').then(function(){" & "$.get('" & $AddRecordThree & "').then(function(){" & "$.get('" & $AddRecordFour & "').then(function(){" & "$.get('" & $AddRecordFive & "').then(function(){" & "$.get('" & $AddRecordSix & "').then(function(){" & "$.get('" & $AddRecordSeven & "').then(function(){" & "$.get('" & $AddRecordEight & "').then(function(){" & "$.get('" & $AddRecordNine & "').then(function(){" & "$.get('" & $AddRecordTen & "').then(function(){" & "})" & "})" & "})" & "})" & "})" & "})" & "})" & "})" & "})" & "});" & "void(0);" //end code Where do I insert $DisplayRecord? I've tried numerous different spots, can't get it to work. Thanks in advance!Re: URL Formula Button Refresh current page not Redirect
I'm interested in modifying the javascript above to include a location redirect in the script. var text DisplayRecord= URLRoot() & "db/" & [_DBID_TASKS_POC] & "?a=td"; "javascript:" & "$.get('" & $AddRecordOne & "').then(function(){" & "$.get('" & $AddRecordTwo & "').then(function(){" & "$.get('" & $AddRecordThree & "').then(function(){" & "$.get('" & $AddRecordFour & "').then(function(){" & "$.get('" & $AddRecordFive & "').then(function(){" & "$.get('" & $AddRecordSix & "').then(function(){" & "$.get('" & $AddRecordSeven & "').then(function(){" & "$.get('" & $AddRecordEight & "').then(function(){" & "$.get('" & $AddRecordNine & "').then(function(){" & "$.get('" & $AddRecordTen & "').then(function(){" & "})" & "})" & "})" & "})" & "})" & "})" & "})" & "})" & "})" & "});" & "void(0);" Where do I insert $DisplayRecord? I've tried numerous different spots, can't get it to work. Thanks in advance!5Views0likes0CommentsMulti-Select Buttons
I have numerous buttons all designed to add a certain type of child record from the parent table to the child table. I also have one designed to add all the children records. Instead of having so many buttons, I'm wondering if I can have a multi-select field to choose which buttons I want to execute. Say I don't want to run all, but buttons 1,5,7,&11. Is it possible to create a multi-select button?