Custom Save and Close button
Hello everyone, This is probably a super simple solution but for the life of me I have not been able to get it to work. I am trying to create a custom button that simply saves the record on a form that has both the parent and the child records in edit mode. Example: A parent record form has an embedded grid of related child records. When the parent record is in edit mode, the grid of child records is editable, so that the user can add or modify the related child records. At this point, the parent record has already been saved, so the record ID of the parent already exists. All I want my button to do is to save any changes made to both/either the parent or the child records. I want this button to work exactly like Quickbase's native "save & close" button. Thanks in advance for your help! ------------------------------ Juan Solorio ------------------------------99Views0likes5CommentsSave and Redirect Button That Passes New Record ID
The high-level desired workflow: Add New Record (does not have a Record ID assigned) Add information into [Field A] Click button or link on the form that Saves the Record (thus creating a Record ID) Redirects to a URL that passes both [Field A] and the newly created Record ID Additional information: The URL this information is being passed to is an API to an external system (not QuickBase) I'm unable to use the built in QuickBase webhook functionality because the URL being directed to is an internal network server. The browser on our devices has certificates created to make this server a "trusted" URL so we can navigate to it directly within the browser, however QuickBase attempting to reach our server using a webhook does not have a certificate and does not trust the location, thus it cannot be seen I am able to get the "Save and Redirect" portion working using build found in this thread, however I'm unable to pass the newly created record ID because at the time the formula link is being generated, it doesn't exist:https://community.quickbase.com/communities/community-home/digestviewer/viewthread?MessageKey=c59408cb-2abc-4bd8-94cf-e4e487fc7e7d This is the closest existing thread I could find requesting the same functionality, but am no where near getting it to function:https://community.quickbase.com/communities/community-home/digestviewer/viewthread?MessageKey=5cf176ce-f70c-4a33-915c-f43db707d774 Any ideas?? ------------------------------ Scott Robertson ------------------------------62Views0likes1CommentAPI button to add new parent record
Hello, I'm wanting to add an API button in a child table that would add a parent record and also add the parent record id to the related field in the child record. Basically the same thing that adding a record from a record picker does but pre-populate fields in the parent record. Is this possible? Thanks in advance for any advice! ------------------------------ Sam Rettig ------------------------------54Views0likes7CommentsFormula URL Redirect to Report
Hello, I have a formula URL I am using as a button on a report to allow the user to add a new record. Once they save the record is there a way to redirect them back to the report they started from? Currently, when i click save and close it redirects me to the saved record view. I have tried adding & 'rdr=" & URLEncode(URLRoot() & "db/" & & "?a=q&qid =130" ) and also have tried just putting the direct link for the report into the formula but neither change the behavior when the new record is saved. ------------------------------ Thanks in advance, Jennifer Paschal ------------------------------39Views0likes2CommentsDate stamp formula for checkbox
Hello. I have a quick question regarding date stamps. I have two check-boxes on my form: import and export. For both, I hope to create a formula date stamp field to see when users ticked these boxes. We have a few older records to see when they were imported and exported. When they built this application, they did not anticipate the importance of these check-boxes. Is this at all possible? Thank you very much for all of your help!33Views3likes23CommentsHow to Add CurrentUser to User List field
I have searched the API, formulas and community and don't see anything. Wondering if there is an API function for adding the current user to a User List through a URL Formula? The idea is to expose a button on a report that says Subscribe on it. When the User clicks the button their username is added to the User List field. The report is displayed on the App Home page, where each record is a separate topic of interest. We won't have a lot of Subscribers so a User List is ok. We want to experience to exclude opening the record and adding the User name to the list. This doesn't work: URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#] & "&_fid61=User()&apptoken= URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#] & "&_fid61=[??WHAT DO IT PUT HERE??]&apptoken= Thoughts? ------------------------------ Jim Harrison ------------------------------24Views0likes11CommentsSyntax for a Rich Text formula field type which changes color on hover before click
There is a post here which explains how to get a formula rich text button to change color when hovered. Here is an what was used to create the effect: "<a class='Vibrant Primary' style=\"width:310px; text-align: center; background-color:#6BBD57; Your button function code goes here>Your Button Name Goes Here</a>" https://community.quickbase.com/communities/community-home/digestviewer/viewthread?MessageKey=982fbbc5-96fc-4863-a768-8201b12d92b0&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer#bm982fbbc5-96fc-4863-a768-8201b12d92b0 Rich Text But I am looking to get a similar effect on syntax below where I have more control over the size of the button and the color. Does anyone have some example working code to post from one of your apps which would do that? $Button Words = "Word formula here"; var text txtcolor = "white"; var text style = "style=\"text-decoration: none; width: 70px; text-align: center; background:" & $bgcolor & "; border-radius: 5px; padding: 8px 5px; color: " & $txtcolor & "; display: inline-block; font: normal 700 24px/1 \"Calibri\", sans-serif; text-shadow: none;"; // End button style "<a " & $style & " href=" & $URL & ">" & $ButtonWords & "</a>" ------------------------------ Mark Shnier (YQC) Quick Base Solution Provider Your Quick Base Coach http://QuickBaseCoach.com mark.shnier@gmail.com ------------------------------23Views0likes0CommentsMulti-file Upload
Using magic buttons to upload multiple files and it is working great. I have one app that I would like to do the same but the files have a type associated with it. For example, I need to upload 10 files and chose the file type as "drawing" or "email". Any suggestions on how I do that? ------------------------------ Sarah Burres ------------------------------22Views0likes1CommentURL Button to Preview File
I have a file attachment and I'm looking to make a button for the user to preview the file attachment. I found an old thread about this suggesting the following, however when I click that I get a url cannot be found web page. Also, it opens in the same tab as quickbase, and I am hoping to open in a new tab. Can anyone help? Thanks! if ([Document]>"", "<a href=\"" &URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#]& "/e999\"target=_blank\">" & [Document]& "</a>","") change the 999 ine999to be the field id of the Document field ------------------------------ Mike Tamoush ------------------------------21Views0likes21Comments