Update Date & Time field with URL Button
Hey Community, I'm working on some cool approval functionality and want to be able to use a URL button field to 1, change the status and 2, update the date and time of a field. I have everything worked out excepted for the date and time stamp of "today" or "now" & "fid_67="Today()" what's is the proper formula to update this field to the current date and time? Let me know if you need any additional information. Thank you :) ------------------------------ Jack Woods ------------------------------199Views0likes3CommentsMaking a Rich Text Formula Field into a Button
I am not very fluent in coding, even at the basic level. I found on a different post the formula below for a "Save and Keep Working" field to appear in the middle of a form but can't figure out how to make it appear like a button. "<div style='Vibrant Success' onclick=$('#footerSaveAndKeepWorkingMenuOption').click();>Save and Keep Working</div>" A button similar to the "add record" buttons that are automatically created Thanks in advance! ------------------------------ Ryan Whitener ------------------------------152Views0likes3CommentsCreate a simple edit record button
I am attempting to create a button to use on a table or a form to allow not so familiar users to find easily. I am using this formula "?act=API_EditRecord" in a URL-formula field but am getting an error. Is the URL-Formula field the way to go? ------------------------------ Michael Hall ------------------------------100Views0likes2CommentsCopy Master & Detail Records bottun
Hi Everyone, I'm pretty new to QuickBase so I 'm not sure if this question is addressed somewhere else or not. I created a button to copy a record and it looks like the formula is working fine. I'm just wondering if there is any way to modify this formula? Basically, I would like to change the value of a specific field(the field is a Text - Multiple Choice) when I copy the record. Copy Formula: "javascript:void(copyMasterDetailButtonHandler('&relfids=61,14©Fid=6&destrid=0&sourcerid=" & [Opportunity #] & "', 'br74dayx8'))" ------------------------------ Michael Naser ------------------------------66Views0likes1CommentCustom Button Working on Browser/PC - Not on Mobile?
Hey Community, I made a simple button so that external web users could submit records into my table. It works great on PC but does not seem to save the record on mobile. On mobile it just does the redirect. This caused some issues because I thought it was working - when really it wasn't submitting any of the details the user just entered. How can I update my button to make sure it's saving the record on mobile then redirecting to that other webpage? URLRoot()&"db/"&Dbid()&"?a=dbpage&pagename=thankyou.html&ifv=20" ------------------------------ Jack Woods | Low Code 4 Lyfe ------------------------------53Views0likes8CommentsURL Language
I am trying to find a good tutorial that will help me to create a button to return to the related record in a parent table. I see some discussions in the Community but I don't know the language. Is there a tutorial on the URL formula language? In the short term, I want the button, but in the long term, I want to learn this so I know what's going on. Thanks! Mike ------------------------------ Mike michael.rorstad@ameebay.com ------------------------------40Views0likes4CommentsMissing "rid" parameter.
i have created one formula (button) which updated the checkbox to checked and redirect to the new custom page. URLRoot() & "db/" & Dbid() &"?a=API_EditRecord&rid="& URLEncode ([Record ID#])& "&_fid_24=" & URLEncode("true") & "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid()&"?a=dbpage&pageID=4") but i got rid parameter error. <qdbapi> <action>API_EditRecord</action> <errcode>30</errcode> <errtext>No such record</errtext> <errdetail>Missing "rid" parameter.</errdetail> </qdbapi> ------------------------------ preeti verma ------------------------------38Views0likes5CommentsModify Add Task Button to Checkbox on New Task/ Sub-Table
Hey Community - I'm looking to simply modify the existing/standard "Add Task" (Sub-Table) Button on my Parent table so that it can update a checkbox field for me on the new sub-record being created. I modified the URL formula code but it doesn't seem to work and just takes me back to the home screen - no error message. the checkbox field is FID194. Please let me know what's wrong with my code below. Thank you, URLRoot() & "db/" & [_DBID_TASKS] & "?a=API_GenAddRecordForm" & "_fid_192=" & URLEncode ([Record ID#]) & "&_fid_194=true" & "&z=" & Rurl() ------------------------------ Jack Woods | Low Code 4 Lyfe ------------------------------31Views0likes2Comments