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 ------------------------------52Views0likes3CommentsCreate 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 ------------------------------33Views0likes2CommentsCopy 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 ------------------------------25Views0likes1CommentCustom 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 ------------------------------12Views0likes8CommentsURL 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 ------------------------------10Views0likes4CommentsMaking 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 ------------------------------10Views0likes3CommentsMissing "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 ------------------------------10Views0likes5CommentsCreate a table record with a custom formula URL button without using a relationship
I'm trying to figure out a way to allow users to create a table record via a formula URL or formula rich text field button while still hiding the button to add a record to the table directly. I want to programmatically allow them to create only a specific type of Operations Task, like a Service Only task which I can program into the button with a URLEncode("Service Only") method in the GenAddRecordForm API button. Each record below represents a patient where the technician is able to add a task from a Patient's table, but only for a specific patient. What I'd like to do is create a formula URL or formula rich text field that allows the user to create a generic task record in the Task table, without having to associate a patient with the task. The issue I'm having is where do I put this (formula rich text) button that I created in the Operations Tasks table? I tried to add it to the technicians home page, but there's no option to add a custom button to a home page. I also created a code page with a button using fetch and the RESTful Insert/Update record(s) API, but this only creates a new record without directing the user into QuickBase to view the record that was created. Is there any way to add the custom formula URL button to the tech (user) home page or somewhere that is not directly related to a line item record in another table? ------------------------------ AR ------------------------------8Views0likes0Comments