Recent Discussions
Formula URL - Edit then Add
Hello Everyone, I'm trying to create a single button that will allow our users to add an effective end date to a record on form ID 11 and then when that is saved redirect to the add record api using form ID 10 populated with data from the previous record. Since I haven't been able to get it to work in a single button I created 2 buttons. Indivually both buttons work but combining them isn't. Any ideas? Step 1 code: URLRoot() & "db/" & Dbid() & "?a=er&rid=" & [Record ID#] &"&dfid=11" & "&rdr=" Step 2 code: URLRoot() & "db/" & Dbid() & "?act=API_GenAddRecordForm&dfid=10" & "&_fid_6=" & [Paragraph] & "&_fid_7=" & [Publication] & "&_fid_8=" & [Description] & "&_fid_11=" & URLEncode([Staff Contact]) & "&_fid_17=" & [Effective End Date] & "&_fid_19=" & [Record ID#] When I combine the code I'm using this URLRoot() & "db\n/" & Dbid() & "?a=er&rid=" & [Record ID#] &"&dfid=11" & "&rdr=" &URLEncode(URLRoot() & "db/" & Dbid() & "?act=API_GenAddRecordForm&dfid=10" & "&_fid_6=" & [Paragraph] & "&_fid_7=" & [Publication] & "&_fid_8=" & [Description] & "&_fid_11=" & URLEncode([Staff Contact]) & "&_fid_17=" & [Effective End Date] & "&_fid_19=" & [Record ID#]) I feel like I need a pause before the & "&rdr=" in the third line as I get an error saying something went wrong. For now I will keep it 2 separate buttons but it would be great to combine them and using the save function on the edit record to trigger the second step.Solved0likes4CommentsDate value changes when copied to new table with pipeline.
I am updating an app with a [Fines] table that has 10 pairs of Pmt-Dt-* and Pmt-Amt-* fields. The date fields are Date (not Datetime). 1) I created a new [Payments] with Fine-ID, Pmt-Dt, and Pmt-Amt fields. The new table will support online payments, so we want the new Pmt-Dt field to be Datetime to differentiate between multiple payment attempts on the same day. 2) I created a pipeline to read each Pmt-Amt-* of each record. If Pmt-Amt-* > 0, then the pipeline inserts the payment into the [Payments] table. ISSUE: Although both tables are in the same application, the new [Payments] table dates are created with a timezone adjustment. The application is UTC-05:00 (Eastern US & Canada). • 2012-02-02 (in original Fines table) is inserted as 2012-02-01 19:00 in the new table (5 hours earlier). • 2018-08-08 (in original Fines table) is inserted as 2018-08-07 20:00 in the new table (4 hours earlier, during DST). I can probably use time.delta(hours=5) and time.delta(hours=4) to update the original values, but this will require identify the exact spring-forward and fall-back dates for each year with payments. Is there a better, more automated solution?0likes0CommentsPushing JSON data to external API endpoint
Hello, I haven't been able to find any instructions anywhere on how to setup a Pipeline to push JSON data to an external API endpoint. Ideally, I want to send JSON data to an external API endpoint when a record is created, or modified via pipelines. I was able to set this up with a Webhook, but Pipelines doesn't seem as obvious. Thanks, James0likes0CommentsCreate and edit child and grandchildern from within a parent form help please
I am using legacy forms to try and accomplish this. I have these tables in use: Expense, Dates of Service, Invoices and Links to invoices. Expenses is the parent to Dates of service, Dates of service is the parent to links , and Invoices in the parent to Links. 1 Expense has many Dates of Service 1 Date of Service has many related Invoices 1 Invoice can have many linked DOS's (which need to connect to the related expense) What I want to do is streamline my process and try to add the date of service AND then link that DOS to an invoice, all while staying on the Expense's table and at one time. Currently, after creating the expense and date of service, I then have to go to the DOS table in order to create a link between the dos and invoice. My process goes like this: I receive and enter a new expense in the expense table. Since each new expense has many different Dates of Service (DOS's) I have the DOS table. On my expense form I have an embedded grid edit report from the DOS table so I can add each DOS and its specific cost while I am entering the new expense. So basically each expense has many line items, which are the dates of service. And then each date of service has many related invoices which I connect via my links table. I log the expense details with the total due for all the dates of service listed on the expense, ie total expense balance due = $1000.00 The $1000.00 due is for 2 different dates of service, which I log via the embedded grid edit dos report on the expenses form. Then..... DOS #1 - $500.00 amount Due - DOS#1 has 5 different related invoice (each related invoice belongs to 1 patient account and then the $500.00 cost for the dos is divided and out among the related invoices and tallied in a another place to be displayed on each patients record. DOS #2 - $500.00 (same scenario) This allows us to account for the expense's for each date of service for the related invoice we have sent out. So how can I accomplish this all with the expenses table at one time? I was thinking that I could use a save and keep working button after the expense and dos details are entered? I do have a relationship between the expense and links to dos tables but I would think I need to i want to link the dos to the related invoice using that relationship? Hopefully I am just overthinking this and it is an easy solution. Any help is awesome.0likes0CommentsJira Assignee
Good morning, I've created a pipeline to create a Jira story when an issue record is created in QuickBase. Most of it is working, but I can't seem to get the Assignee and the Reporter fields to work. I'm thinking it is because they are user fields? Is there something I need to do to convert the QuickBase data to what Jira needs in these user fields? I've tried using each of the options (email, first/last name, screen name) but it just appears as blank in the Jira ticket. Thank you!0likes0CommentsLogging causes dynamic rules to not work
I have an approval box that I want to log when and who approved or rejected. When they reject, an email should send and another box should come up to the right of the notes box. I assume because of the log, it is causing my rule to fail? Dynamic rule0likes2CommentsEmbedding Reports in Report Link Field with New Forms
I'm hearing that you can embed reports on the new forms. I know how on the old forms, but am puzzled how on the new forms? My three uploaded snapshots, two show a Warranty Table form, the old form, and then customize report option to embed a report in a report link field. The third snapshot shows the new form with the same report link field, but I'm not sure how to embed the 'Embedded for Warranty' report on the new form? ------------------------------ Bob T. ------------------------------0likes3CommentsRe-establishing relationships in migrated databases
I need to understand how to re-establish relationships on existing tables that I have migrated into Quickbase. I know am absolutely missingsomething that is probably pretty obvious. Its an MSAccess database, so its SQL compliant. I have a table with important information in a field that I want to preserve. This is the field in the child table--lets call the field BigInfoValue (a numeric field) and the table ChildTable. I have a tiny table with other information in it that defines what the values in BigInfoValue mean. Lets call this BigInfoParent table, and lets call the fields BigInfoValue (a numeric field I want to relate the tables on which I've also designated the key field), BigInfoTerm, and BigInfoDefinition. I absolutely cannot figure out how to make the two tables link on BigInfoValue. When I try to create a table relationship, with BigInfoParent, Quickbase does not offer me BigInfoValue in the child table as a linking field. It creates a brand-new field called Related BigInfo something something. I've also tried to establish a table relationship with the RecordID field in BigInfoParent to BigInfoValue in the ChildTable. No dice. Quickbase just doesn't offer me the field that I think should be linked. Any help would be appreciated.0likes1Comment