Exact Forms - Extra Spaces with Rich Text fields
I have a multi line rich text field in an exact form. In the past I used html to manage the spacing which worked fine. When Quickbase changed the formatting on this field I can no longer use html in the field successfully (I can put html in the source). My issue is for every hard return it adds an extra space at the bottom of the text. I used to be able to use </br> and write all the text on one line to eliminate this problem
Assign multiple child records simultaneously
Hello, I'm looking to add several child records to a parent in one go if possible. The parent is the Projects table. At the moment I have child tables for Diseases and Geographies which are added in the usual way. This is a bit of a hassle as there are usually 10+ geographies per project. I want to expand on this by adding more tags so we can fin relevant projects in the future. These tags will likely reside on one table and if necessary I can move the geographies and diseases to this table. My question is, is there a simple way to select and add several of these tags to the parent record, much like you see on numerous websites, including the field right below where I am typing now(!)? I am aware there is a wizard which sets up a button but I've only got the Essentials package which doesn't allow this. I'm not averse to upgrading if this is the right solution but wanted to throw it out there first. Thanks in advance
Using a barcode scanner to associate multiple existing child records to a parent record.
I am trying to integrate barcode scanning into the app I am developing in order to track and manage the manufacturing process at my companies manufacturing plant. The plan is for each part to be assigned it's own unique QR code (essentially representing the unique record ID of each part in quickbase) and to scan that QR code at each stage of the production process to ensure that every part is tracked as it moves through the plant. Eventually all of the parts are put onto a pallet before being shipped out. I am currently looking for a way to streamline the palletization process. In my app I have a Pallet table that is the parent table to the Parts child table. The way I imagine the process working is that each pallet will have a QR code which, when scanned, would allow a user to scan the QR codes for all of the parts that are going on that pallet and then clicking a save button that would relate the scanned parts to that pallet. I'm imagining this could be done using the Quickbase API using something similar to the "add child record" button that is automatically created in the parent table when creating a relationship, but instead the "button" would be a scan and instead of creating a new record it would update the "related pallet" (the parent record) field of the exiting part records for all parts scanned prior to clicking the save button. ------------------------------ Ben Krieger ------------------------------
Conditional Logic in Exact Forms
I am using Exact Forms and am wondering how to hide or collapse fields on the exact form if there isnt a value in there. I am having the fields show up on my QB form but if they are blank I dont want that transferrring over to my exact form. I have dynamic rules in my QB form but that doesnt help my Exact form right now. Something similar to this: Case([Quantity], <1, Hide [Cost], > 1, Show [Total Freight $] )
Automatically Sending an Exact Form in an Email
Hi, I have just created and properly uploaded an exact form for an application in quickbase. I was wondering if there was a way to make a button or possible pipeline that will automatically send an email with the completed exact form attached. By completed I mean the data fields within the exact form are filled out and not with the raw code. If it is possible, any help/explanations about how to do it would be greatly appreciated. Thank you! ------------------------------ Tom Leick ------------------------------
File Link -> URL with Path
"https://core.federatedservice.com/apps/downloads/dynamic_workorder.php?" & "clientid=Q1752" & "&appid=bhv9szun5" & "&tpdbid=" & [_DBID_DOCUMENT_TEMPLATES] & "&tpid=1" & "&fn=WorkOrder_" & [Work Order #] & "&msid=" & URLEncode ([Record ID#]) & "&msdb=" & Dbid() & "&faid=592" & "&efpdte=593" & "&addfiles=" & "&docfmt=pdf" & "&stream=y" & "&apptoken=d3dzsz2cndv7n7bbg5y8q87xbw4" & "&doc_name=" & "WorkOrder_" & [Work Order #] & "_" & [Record ID#] & "&file_name=" & "WorkOrder_" & [Work Order #] & "_" & [Record ID#] & "&file_link=" & "https://fss.quickbase.com/up/bhv9szup6/g/rb3tz/eus/va/WorkOrder_" & [Work Order #] & "_" & [Record ID#] & ".pdf" & "&customer_rid=" & [Related Customer] & "&project_no=" & [Project #] & "&project_rid=" & [Related Project] & "&workorder_no=" & [Work Order #] & "&workorder_rid=" & [Related Work Order] & "&visit_rid=" & [Record ID#] & "&partner_rid=" & [Related Deployment Partner] & "&technician_rid=" & [Related Technician] & "&is_internal_download=true" & "&user_name=" & URLEncode(Trim(UserToName(User()))) & "&user_email=" & URLEncode(Trim(UserToEmail(User()))) This formula calls our javascript code, which in turn invokes your aspx code thusly: var wko_link = 'https://www.quickbaseutilities1.com/FederatedServices_1752/DocumentMerge/doc_merge_UA.aspx?' + 'clientid=' + $.url.param('clientid') + '&appid=' + $.url.param('appid') + '&tpdbid=' + $.url.param('tpdbid') + '&tpid=' + $.url.param('tpid') // Record Id of the specific document template + '&fn=' + $.url.param('fn') + '&msid=' + $.url.param('msid') + '&msdb=' + $.url.param('msdb') + '&faid=' + $.url.param('faid') // faid=file attachment field & efpdte=date document was created + '&efpdte=' + $.url.param('efpdte') + '&addfiles=' + $.url.param('addfiles') + '&docfmt=' + $.url.param('docfmt') + '&stream=' + $.url.param('stream') + '&apptoken=' + $.url.param('apptoken'); This all works as we intend, and dynamically creates the desired work order file, calling the Exact Forms Plus code indirectly instead of directly. But it appears that the line in our code ("&file_link=" & "https://fss.quickbase.com/up/bhv9szup6/g/rb3tz/eus/va/WorkOrder_" & [Work Order #] & "_" & [Record ID#] & ".pdf") fails to save the correct path to the dynamically created work order. Our guess is that the value "rb3tz" in that line should be a variable, as it seems to change in the different dynamically created work orders. But we do not have any idea how that value "rb3tz" is created. Is there any way we can calculate that value ourselves? Or is that even a 'good' solution to our problem of saving the url? We tried using the "Work Order Document" field that Exact Forms Plus fill in the Site Visits table (which we read via the QuickBase Do_Query API), but the API seems to only return the file name, not the entire path to the file. We assume this is because it is not a URL field, but a File Attachment field. This is strange, since when we hover a mouse over the value in the Site Visits table, it does show the entire url at the bottom of the screen (see screenshot below). To reiterate, when we look at our QuickBase Site Visits table, we see that the Exact Forms Plus aspx code IS in fact storing the file, and saves what appears to be a link to it in the "Work Order Document" field which I have circled in the screenshot below. Hovering a mouse over the "Work Order Document" field reveals the url link to the file at the bottom of the page, which I have also circled. But we have been unable to retrieve this entire url through the Do_Query API, getting instead only the file name. We notice that the path in the url seems to have a different value for each different document created where we see "rb33r" in the screenshot below (which I have underlined in red). Other than this value, we believe the path is always the same for other dynamically created work orders. Can you offer us any advice on how to save the path to the work order dynamically created by the call to Exact Forms Plus? Whether by dynamically creating our own path to the file or by somehow reading the path underlying the "Work Order Document" field? Thank you. ------------------------------ Earl Adkins ------------------------------
Web Form HTML Wizard To ADD Record for Internet Users
We are using a web form containing the HTML Wizard with the API Add Record to add records to a table in Quickbase.My question is how do I get the web user to see the results that QB calculates. At present I have created a Thank You form in QB Forms.As soon as the record is created in QB the Thank You Form is displayed ( with different calculated results for each record) ( In QB) .However,when the record is added using the web form I am not sure what URL to redirect to so the web user can see the results pertinent to their record. My question is two fold 1) What URL to redirect to .I know the url has some dynamic fields which change each time a record is created 2) Can this also be achieved with the APIGetRecordAsHTML. Can someone please guide me.I have the submission working ,the results are accurate in qb....the issue is displaying the Thank You page with the results and/or fetching the record as html and displaying
