PRINTING NEW FORMS?
Is there a way to Print the new forms yet? Would like to put a button on my legacy table on a record id to print that new form style that would show the .jpg of the attachment when printing. If not, is there an easy way to do this with a record that has 5-20 attachments when printing or emailing only?14Views0likes1CommentFORMS as a primary view in a Table?
I have been out of QuickBase for a couple years and a lot has changed. Hence, my return to Empower this year! I am playing around with Forms and want to see if there is a way to integrate this view into my Tables as a primary view instead of a report/ legacy view? It seems this would be a nice view to have within the tool as well instead of just for use in other places? Let me know if I am missing something as I cannot find how to use forms without a link/ email/ etc. Thanks in advance!17Views0likes2CommentsHow do I save a form and continue to another form, importing the newly created RECORDID?
Hi all, I've been trying to sort this out for too long. I have a form (Form A) with a URL link to another form (Form B) for the same Table. When you click the link it should save the form, create the RECORD ID and use that RID to go to Form B. For some reason the "%%rid%%" functionality isn't working for this. Here is the formula I am using: var text recordid = "%%rid%%"; URLRoot() & "db/*********=er&dfid=24&rid=" & $recordid & "&z=" & Rurl() & "&ifv=1" It says: "DRS Record not found". When I look at the URL that it directed me to it still has "%%rid"" in the actual URL instead of the new Record ID. I have tested this url by hard coding in the next RECORD ID that will be created and the URL link works. I just need the new RECORD ID to be in the formula - URL and it's all golden.32Views0likes2CommentsTotaling Child Records Live on Parent Form
I have created a parent table called "time reports" and a child table called "time spend on projects." On the "Time Reports" form, the user is able to enter the percent of their time they worked on each project using a grid edit/editable embedded table. The child records in the report have already been created by a pipeline. The user just enters the percent. The user does not create any new rows. I'd like the user to be able to see that their percents total 100%. I have created a summary field on the "Time Reports" form, but it doesn't update until the record is saved. I tried creating a button to just reload the page (having the auto-save setting turned on), but the data entered in the embedded table isn't saving, so it totally clears their work. Do you know a way to check the total value of child records while on a parent record live? Or a work around? I looked for past posts on this topic, but couldn't find any. Maybe I was trying the wrong key words. If you know of another post with the answer, please send it my way! Any help would be greatly appreciated.Solved32Views0likes6CommentsRequired Fields Not Validating on Edit Form with Custom Save Button
I have required fields in one of my forms. I'm using a custom button to save the form. When I click the "Save" button, it checks for the required fields in the Add Form, but it doesn't perform the validation in the Edit Form. How can I ensure that required field validation works on the Edit Form as well when using the custom save button? This is the custom button formula: // Define the container style var text container = "display: flex;" & // Use flexbox layout for arranging children "justify-content: center;" & // Center all child elements horizontally "gap: 17px;"; // Add space between child elements // Define the subcontainer style var text subcontainer = "display: flex;" & // Use flexbox layout for subcontainer "justify-content: center;"; // Center all child elements horizontally // Define the button container style var text buttonContainer = "width: 130px;" & // Set fixed width for the button container "display: flex;" & // Use flexbox layout "flex-direction: column;" & // Stack buttons vertically "gap: 10px;" & // Add space between buttons "padding: 5px 3px;" & // Add inner spacing (5px top/bottom, 3px left/right) "border-radius: 8px;"; // Round the container's corners // Define the orange button style var text orangebutton = "border-radius: 40px;" & // Fully round the button's edges "color: #ffffff;" & // Set the button's text color to white "background-color: #f8761f;" & // Set the button's background to orange "font-family: Roboto, sans-serif;" & // Use Roboto font with sans-serif fallback "font-weight: 700;" & // Make the text bold "font-size: 12px;" & // Set the text size "padding: 12px 40px;" & // Add spacing inside the button (12px vertical, 40px horizontal) "display: inline-block;" & // Ensure the button behaves like an inline-block element "line-height: 20px;" & // Set the line height for text "text-decoration: none;" & // Remove underline from the button text "text-align: center;"; // Center the text inside the button // Define the black button style var text blackbutton = "border-radius: 40px;" & // Fully round the button's edges "color: #ffffff;" & // Set the button's text color to white "background-color: #252525;" & // Set the button's background to black "font-family: Roboto, sans-serif;" & // Use Roboto font with sans-serif fallback "font-weight: 700;" & // Make the text bold "font-size: 12px;" & // Set the text size "padding: 12px 40px;" & // Add spacing inside the button (12px vertical, 40px horizontal) "display: inline-block;" & // Ensure the button behaves like an inline-block element "line-height: 20px;" & // Set the line height for text "text-decoration: none;" & // Remove underline from the button text "text-align: center;"; // Center the text inside the button // Define the Record ID or placeholder if not available var text rid = If([Record ID#] > 0, // Check if a Record ID exists ToText([Record ID#]), // Use the existing Record ID "%%rid%%" // Placeholder for new records ); // Define the close window URL var text closewindow = URLRoot() & "db/" & AppID() & "?a=dbpage&pageid=11"; // URL to redirect to page 11 after an action, which closes the popup page // Construct the Submit URL var text Submit = URLRoot() & "db/" & Dbid() & // App root and database ID "?a=API_EditRecord&rid=" & $rid & // API call to edit a record using Record ID "&_fid_23=" & URLEncode("Pending FP&A Approval") & // Update status field with "Pending FP&A Approval" "&_fid_25=2" & // Update field 25 with value 2 "&_fid_26=1" & // Update field 26 with value 1 "&rdr=" & URLEncode($closewindow); // Redirect to the close window URL after editing // Construct the HTML structure "<div style='" & $container & "'>" & // Outer container with flexbox layout "<div style='" & $subcontainer & "'>" & // Subcontainer centered within the outer container "<div style='" & $buttonContainer & "'>" & // Button container for Cancel button "<a style='" & $blackbutton & "' href='" & $closewindow & "'>Cancel</a>" & // Cancel button styled as black "</div>" & If([Payment Request Status] = "New", // Conditional logic for Submit or Save button "<div style='" & $buttonContainer & "'>" & // Button container for Submit button "<a class='SaveBeforeNavigating' data-replaceRid=true style='" & $Orangebutton & "' href='" & $Submit & "'>Submit</a>" & "</div>", "<div style='" & $buttonContainer & "'>" & // Button container for Save button "<a class='SaveBeforeNavigating' data-replaceRid=true style='" & $Orangebutton & "' href='" & $closewindow & "'>Save</a>" & "</div>" ) & "</div>" & "</div>" This is the code page content: <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>Title</title> </head> <script> window.close(); </script> <body> </body> </html> Any help would be greatly appreciated!39Views0likes3CommentsAllow users to edit multiple forms
Hi all, I have two forms - 2024 and 2025 versions of the same form. I would like to simultaneously allow users to: Click the edit button next to a record and be taken to a certain form (ex. 2024) Click a link and be able to editeither the 2024 or 2025 form Right now #1 is working fine, but #2 brings up the "primary" form (aka the one that is set in the Forms menu for edit permissions for all roles) regardless of the form ID I use in the URL. Is there some way I can override what form is utilized for the URL fields?31Views0likes5CommentsHave a rich text button span the width of mobile Device
On legacy forms, when using a mobile device there were some ways to make a rich text button span the width of the mobile device. You could use: class='Vibrant' or in the styling you could use width: 100%. Neither of these tricks work on the new forms (on mobile). Does anyone know of way to make a rich text button span the width of a mobile device on new forms?11Views0likes0CommentsNew Forms - Editable Embedded Report
Hello, Does anyone know if they've released similar functionality to the legacy forms that allows editing embedded reports? We have a new form that needs a child relationship to capture n-records. The problem is that this record creation is available to EOTI and they should only be able to Add Records, not View or Edit. In other words, if they navigate away from the record they're creating (parent) to create a child they'll never be able to get back!50Views0likes7CommentsWhy Quickbase? Why?
One of the few things I ever said that Quickbase lacked was design capabilites, particularly in form design, and when I saw that they were making changes to that I was pumped. Now that I have used it a bit, I am scratching my head... Although I do love some of the options they have added, why would you take away things like being able to have the field label on the side or on top? And the addition of columns was great! But why take way the ability to have a couple small fields still be able to be on the same line within those columns? I'm trying to mimic a form that is currently in Excel and the section that currently only occupies only about a 3rd of the page, a user will have to scroll down to finish entering all the info because of the spacing. Am I missing something or does forms design still need some work?33Views0likes2Comments