Looking for simplest example to access quickbase using python
Can someone point me to examples that show how a quickbase/db can be accessed from the command line/using python -? We would like to access, add, delete, change records and create reports - and in addition to the GUI provided, do such using CLI tools and python (saw pybase on github, am having some difficulty with it - unless someone can provide a complete example -?)38Views2likes22CommentsCreate new records using data from a multi-select field
When I save a record in a table, I would like to take items selected in a multi-select field in that table and create a record for each item selected into another table. I tried an automation but it only grabs the first selected item. I need it to iterate through each item selected and create a record for each. Any help would be much appreciated.29Views1like9CommentsFormula text button to create Quick Base Action (Add Record) and redirect to that record
I have a formula text button in a table to check a box in one table, fire an Action to create a new record in another table. Right now the formula takes me back to the original table. I need to go to the record in the new table.28Views1like10CommentsCreating a URL based on a record ID
I have an automation that creates a new record on Table B when the existing record on Table A is modified. Due to the specific report I need, I could not create a traditional relationship between these two tables so I created the automation instead. When the new record is created on Table B, it will have a field that references the Record ID of the triggering record from Table A. I would like to make a formula URL field on Table B that creates a link to the triggering record on Table A. My assumption is that I need to do this using the record ID, but I'm not sure how.27Views1like11CommentsAutomation to create multiple records based on a multi-select text field
Hi everyone! I have a tricky question for you. I have a parent table (jobs) with a child table (schedule) with its own child table (crew assignments), which in turn has its own parent table (crew) which is just a master list of the staff. The way I have my app designed, users add schedule items in a grid edit within the main Job form. Then within each schedule item in the grid edit, there's a multi-select text field set up to assign crew members to each schedule item. It's fine, but it's just a multi-select text field that pulls crew names from the master crew table, it's not actually associating crew assignment child records with that schedule item. Having users click a report link from each schedule item and add crew assignments in grid edit mode would be adding too many steps. What I think I need is to be able to do is keep my multi-select text field, but create an automation that separates that list and then creates a child record in the crew assignments table for each name on the list. I haven't done much with list fields in automations so I'm not sure where to start. Or of course, if I'm missing something blindingly obvious about being able to create multiple grandchild records within a grandparent form let me know. Any help would be awesome! ------------------------------ Elena Larrabee ------------------------------24Views0likes6CommentsButton to Add Child Record, Save it, Display it, Reload, then Edit mode
I have a button that adds an Estimate to an Opportunity. The button Adds the child record, Saves it, and Displays it. An automation runs in the background that adds child records to the Estimate. Ideally I want my button to do two more things. Refresh the new Estimate and display it in Edit mode. Here's what I have so far. Any ideas? //This uses the Quick Base API to Add a Related Estimate, Save it, and then display it. URLRoot() & "db/" & [_DBID_ESTIMATES] & "?a=API_AddRecord&_fid_6=" & URLEncode ([Record ID#]) & "&apptoken=mytokenishere" & "&disprec=1"20Views1like4Commentscreating a email button on the form
I have a form called "tickets" for the customer. The app is built for the customer service database. Everytime customer calls in, our customer service team creates a ticket that have all the information and the problem. What I want to do is that create an email button on this form so that when the ticket is resolved, my customer service team can click on the button and send the email straight to the customer which is the customer's email that my CSR team filled out in the ticket at the beginning. I read some of the community questions regarding to this problem but not sure where to start. I also tried some of them but it did not work for me. Can someone please help with this? Thanks!!18Views1like9CommentsCombine values from an entire column of text fields
I have a table of 'Research Words'. It has about 60 rows, each containing a field named 'Research Word'. I would like to have a separate multi-line text field somewhere else that concatenates all those different Research Words. I tried creating a parent table - 'Research Words Combined' - and using the Combine Text summary field. But it turns out that has limit on the number of characters and rows it can combine (I think it's 25 rows). Can anyone suggest a way I can successfully combine all my Research Words into one field?18Views1like2CommentsAutomation Error - 500 Internal QuickBase error
I created Automation which should do following: 1) When Table record "Completion" (checkbox) change and is equal to the value Checked 2) Modify same record in field "Completion date" to capture today date. Sometime it works and sometime not no rule. This time failed when in Grid Edit I Ticket to Complete above 10 records. When it fail no error capture in Automation Box in columnERROR COUNT LAST 7 DAYS bu Ireceive mail with error: "500 Error: Internal QuickBase error" After it happen, automation does not work those records anymore but for other yes. I faced it while marking above 10 records as complete but it is not even close to QB limitation. Any tip to investigate?16Views1like2Comments