ContributionsMost RecentMost LikesSolutionsRe: Creation of new QB Actions and Webhooks will be locked as of June 30, 2024 I second everything that's been said here. The decision to phase out actions and webhooks seems to entirely disregard the user experience of building pipelines on a large scale and the massive level of frustration that comes with it. I use pipelines for one and only one reason; when there is absolutely no other way to accomplish my goal. If it can be achieved via actions, webhooks, code pages, or even a third-party tool, I'll utilize those features over pipelines without hesitation. Why? Because, in actions and webhooks, my work will be reliably saved and my changes won't unexpectedly revert. I will not have to wait 10-20 seconds each time I want to add a new field. My action/webhook won't unexpectedly crash after spending hours perfecting it, and when there is a failure, I will be reliably notified. I don't need to worry about my action failing when I change a field name. I can easily access my actions and webhooks within my app rather than opening pipelines in the shared developer account and searching through hundreds to find the one I'm looking for. If I'm lucky, I remembered to tag it. While the new pipeline builder does improve on some of these issues, it is far from where it needs to be, and it's shocking that those involved in this decision believe that we are anywhere close to ready for this change. The autosave feature is still unreliable, and it is just as likely to fail/crash for no discernable reason. The loading time to retrieve apps, tables and fields has not noticeably improved, as and many others have mentioned, neither has the trigger time. I'm also finding field usage reporting to be inaccurate even after the long-awaited improvements were made. I sincerely hope our shared experiences and frustrations are taken into account, and either the decision to phase out actions and webhooks is rolled back, or the necessary improvements are made to pipelines well before the end of sale date. Re: Trouble with more complex interactions Can you describe the form rule you're using for #3? I've come across the same issue where I wanted to autopopulate a field but allow it to be changed and it kept reverting to the initial value, and I resolved it by writing the form rule like this: If [Field 1] = X and [Field 2] is blank, change [Field 2] to Y That should allow you to change the value of Field 2 after it's been updated to Y, since at that point it's not blank so the form rule doesn't apply anymore. Does that answer your question? ------------------------------ Ahuva Brown ------------------------------ Re: Date field formula that is always the 10th of the next month of a given date. This should do it: FirstDayOfMonth(AdjustMonth([Date Field], 1)) + Days(9) AdjustMonth([Date Field], 1) returns the date one month from the date field. FirstDayOfMonth() returns the first day of the above month. + Days(9) adds 9 days to the first day of the month, returning the 10th day. I hope that works for you. ------------------------------ Ahuva Brown ------------------------------ Re: Date Formula AssistanceHere's the formula I came up with, which should be done in a Formula-Date field: If(Month([Last Inspection Date]) = 3 or Month([Last Inspection Date]) = 4, AdjustMonth([Last Inspection Date], 5), Month([Last Inspection Date]) = 8 or Month([Last Inspection Date]) = 9, AdjustMonth([Last Inspection Date], 7)) The Month([Last Inspection Date]) function retrieves the month number, so if the last inspection date is March, it will output 3, etc. If the month of the last inspection date is March or April (3 or 4), AdjustMonth([Last Inspection Date], 5) adds 5 months to the date. So if the last inspection date is March 1, 2022, the formula will result in August 1, 2022. If the month of the last inspection date is August or September (8 or 9), AdjustMonth([Last Inspection Date], 7) adds 7 months to the date. So if the last inspection date is September 30, 2022, the formula will result in April 30, 2023. Does that make sense? ------------------------------ Ahuva Brown ------------------------------ Re: Date Formula AssistanceI may be misunderstanding the issue, but is there a reason you can't add a fixed number of months to the last inspection date? Meaning, if the last inspection date is between August 1 and September 30, add 7 months to the date to get your next inspection date (using the AdjustMonth() formula), and if the last inspection date is between March 1 and April 30, add 5 months. ------------------------------ Ahuva Brown ------------------------------ Re: Help with GetFieldValue(GetRecords....to lookup value in another tableThe result of the GetFieldValues formula is multi-select text, so it has to be converted to the data type of the field it's in (unless it's already a multi-select text field). So if it's a text field, convert the formula to text: ToText(GetFieldValues(GetRecords("{16.EX.'"&[Date]&"'}","tableB"),25)) ------------------------------ Ahuva Brown ------------------------------ Re: Report Field - Formula Date and concatenate.If you're attempting to concatenate two dates to display on your report, the report formula needs to be Formula-Text, not Formula-Date. You're getting that error because this: &" - "& is a function for text, not dates. ------------------------------ Ahuva Brown ------------------------------ Re: Need two if conditions for a numeric formulaTry this: If([Project Points Override] = 0 and [Approved] = true, [Project Points]*[Contract Coach - Current Rate], [Project Points Override]*[Contract Coach - Current Rate]) ------------------------------ Ahuva Brown ------------------------------ Re: Pipeline to move attachment to another table?You can accomplish this with the Upload a File step in the Quickbase channel (nested under Attachments). This article includes visuals that might help. ------------------------------ Ahuva Brown ------------------------------ Re: Pipelines Jinja HelpAssuming fieldA is a text field, this should be correct: {% if a.fieldA== 'test' %} Your example excluded the quotes. ------------------------------ Ahuva Brown ------------------------------