API 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 ------------------------------
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 ------------------------------How 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 ------------------------------
Multi-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 ------------------------------
Add button to reflect iterms from
Hi, Please help with a code for the add button, I want every time I press it it should reflect in the Stock Item , Quality and Stock code formula fields, as may Items as possible. Currently its a relationship. ------------------------------ Boitumelo Segaole ------------------------------
Issues with pulling info from Parent to Child records
In my app I have an "Entities" table which is a parent table to a "Sub-Entities" table and lastly a "Spaces" table which is a child table to both the "Entities" and "Sub-Entities" tables. They are connected separately to the "Spaces" table so that either can create a new Space. I have both relationships pulling the same info, Entity or Sub-Entity name, contact names, addresses, etc. And when I create a new Space from the Entities table it pulls those fields into the Spaces table as it should, however when I create a new Space from the Sub-Entities table, none of the info pulls over and I cannot for the life of me figure out why it's not working for the Sub-Entities. The only thing I can figure is because the Sub-Entities table is a child table to the Entities table. Any insight as to why this might not be working? ------------------------------ Chris Swirtz ------------------------------Pipeline Simultaneous Multiple and Single Record Creation Ideas
Hi, I am working on a workflow solution and am struggling to solve a problem. Hoping someone in the community who has a bit more experience with pipelines may have a (relatively) straightforward solution I'm not thinking of. Here is what I'm looking to accomplish: Two tables involved: 1. Parent table = A 2. Child table = B Each month, users will have a grid edit report where they can see their B records from the prior month. My idea is they will check the renew checkbox field on this report for B records they want to renew for the current month and save the report. The past month's records will need to stay associated to their A record, so copies of the renewed B records will need to be created and associated with a new A record. The question I have is, how do I get the trigger to recreate (copy) the B records for each trigger, but only create a single A record to tie them to. Example, a user wants to renew 6 B records, so I would need 6 new B records created, but only 1 A record created that all 6 Bs will be tied to. Ideally I want to accomplish this in a single pipeline, if it's not possible then that is good to know. I'm open to other solutions. I feel like this is just an order of operations solution that I can't wrap my head around currently. Thanks in advance for the help! ------------------------------ Curtis Middleton ------------------------------
Formula 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 ------------------------------
URL Button Doesn't Work in Edit Mode
I've got a URL button "Submit" that creates a child record then redirects to the parent table. It works great, but I can't do it while in edit mode, which is really the place I need it. I want staff to be able to click "Submit" as they are entering data and not have to save it the record then click the button. ------------------------------ Bethany Hudson ------------------------------
Print Multiple Exact Forms
I know this has already been covered in a previous post quite a while back and just wanted to re open it in a separate post to see if I can get some help with my specific use case. Here is the old post: https://community.quickbase.com/communities/community-home/digestviewer/viewthread?GroupId=103&MID=30308&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer For my situation, here is my setup at the moment: Work Requests>Poles>Field Work Work Requests have many poles and each pole has 1 field work record. I would've liked to put all field work info in the poles table but the field work table has over 500 fields in it and was a big endeavor at the time of creation so it was separated at the beginning and has a 1 to 1 relationship with poles. My exact form prints locate sheets in a particular format and is within the field work table and each pole will have 1 locate sheet. I want to be able to print all the field work locate sheets for the poles of a work request straight from the grandparent work request table via URL button. Some things I've tried-> I noticed on an ask the user report that "&nv=1&v0=75138760" was at the end of the URL after the qid and I tried combining the print URL with this to make: https://pike.quickbase.com/db/bpfpdy3bx?a=dbpage&sfid=497&pagename=Locate%20Sheet.html&clist=a&qid=23&nv=1&v0=75138760 ..to see if it would print multiple exact forms this way but it shows the exact form for a split second then just turns into a blank white screen, so I'm not sure what else I could do. I can't figure out a good way to make the report necessary to make the normal qid print method mentioned by Keith Jusas to work. Any suggestions? Thanks in advance, #Forms #Button #APIsandcustomcode #Formulaandfunctions ------------------------------ Jordan McAlister ------------------------------
