Recent Content
Date 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?20Views0likes3CommentsTime of Day field values are not in 24-hour format in Pipelines
Hi all. I think I found a bug with Pipelines where using a Time of Day field isn't in 24-hour format even when you set the field settings to 24-hour. Can anyone think of a possible workaround? Most APIs use 24-hour format so having Pipelines only output in North American format makes it impossible to pass along the correct time format. Steps to reproduce: Create a Time of Day field. In field settings > Value display, enable 24-hour clock. Create a pipeline that sends a value in this field. Pipelines outputs the field in North American time format (for example, 5:00 PM), instead of 24-hour format (ex: 17:00). I tried using Jinja to reformat to 24-hour, but Pipelines doesn't support the jinja filters needed to re-format to 24-hour time. Here's the Jinja expression I tried: {{ time-field|replace(" AM", "").|replace(" PM", "")|stringptime("%I:%M")|strftime("%H:%M") }}26Views0likes3CommentsCreate a formula duration over 5 years
Hello, I am trying to figure this out How to calculate a duration for each year based on a varying start date? The start date can be at any month of the year (just calculating months, not days) and the project will last over the next 5 years. Example: IF the Start date is September 2024, there's 4 full months for the first year. And if they're needed for ([Months Needed] is for 12 or 18 or 60 months, then how would I find the duration of the next year, and the next? Would each year need it's own duration field? Like Year 1 duration, Year 2 duration, etc? I'll have these fields [YEAR 1], [YEAR 2], [YEAR 3], [YEAR 4], [YEAR 5]. [Start Date] [Months Needed]21Views0likes1CommentJoin multi-line text field to one line
Hi all. I'm trying to find a way (either using a formula or in Pipelines) to join a multi-line text field to a single line. Use case: The multi-line text field will contain text that will go to the JSON request body of an API call in Pipelines, so the field needs to be converted to a single line. The field has to a multi-line text field, because values can contain several paragraphs and app users can easily customize it. Thanks!40Views0likes4CommentsReport for Expired Training Records
Greetings, We are trying to create an application to store Training Records. Each Function is related to many Training Records. Each Person is related to many Training Records. People [Person Name] (also known as "Trainee" in English speak) Function [Function Name], [Revision Date] Training Record [Training Date], related [Function Name], related [Person Name] (from Person table) We are seeking to build a Report of all Training Records for which the latest Training Date (from Training Record Field for a given Trainee) is before the Revision Date from the related Function field. (If a Person was trained to the Function in 2019, again in 2020, again in 2022, and again on 4/2/2024; only the 4/2/2024 latest training date is examined per the Function Name). We don't want to display expired Training Records if there are newer (non-expired) Training Records to the same Function Name for the same Person Name. What fields/relationships/summary fields/etc. need to be set up to make this work? How do we do this? Thanks, PC6Views0likes0CommentsFormula 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.Solved29Views0likes4CommentsPushing 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, James16Views0likes0CommentsCreate 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.11Views0likes0Comments