MichaelFrishma1
Qrew Cadet
Joined 6 years ago
User Profile
User Widgets
Contributions
Instructions for OAUTH2 using Pipelines
I had the darndest time trying to find out how to use pipelines to get API data when the remote system uses OAUTH2. After lots of trial and error, I was able to make it work, and I figured I would share the info here. Attached are some instructions. These also might be helpful to users trying to get APIs working with JSON data. Comments on this are welcome. ------------------------------ Michael Frishman ------------------------------Re: Fast Field
I haven't been able to find this information about Fastfield. Can a mobile user actually use it to select from a list of Projects in Quickbase, and then fill out and submit data related to that project? From what I can tell, a mobile user can submit data, but it has no relation to and cannot be tied to anything existing in QB. Is this correct? ------------------------------ Michael Frishman ------------------------------Re: New Forms | Saving Glitch
I've seen this, but it was because I had made a change, then clicked Save and Keep Working. My change had triggered a pipeline, which made another change in the record in the background while my view of the record was before the pipeline. If you try to save the record you're on now, it will give you this message. The pipeline was the "other user" modifying the record. I have seen and reported at least 4 other bugs in the new forms, so they are definitely not bullet-proof at this point. ------------------------------ Michael Frishman ------------------------------Re: return value from quickbase webhook pipeline
Have you tried using formula URL's in Kirk Trachy's "Magic Buttons" example app? Specifically "14A. Change Status to Not Started 2.5 Sec DELAY Return (CODE PAGE)". There is a button that links to a code page, which will display a "Processing" screen for X seconds, while the pipeline is running. I use this alot. The user clicks a button. The button formula checks a checkbox, which triggers the pipeline to run. The screen shows Processing, then returns the user to the previous screen. ------------------------------ Michael Frishman ------------------------------Re: Min/Max Dates with Formula Queries
Thanks for the help, but that's not working. If I keep the field as a Date/Time, then I get "Expecting datetime but found date". But if I change the field to a Date field, I lose the flight arrival time which I need to get the Min. ------------------------------ Michael Frishman ------------------------------Min/Max Dates with Formula Queries
I need to use a formula query to find the minimum and maximum date/time for a group of records (Flight Arrival Date/Time) in the same table. I know that there is currently no ability to find the min/max inside the formula query, but I'm trying to figure a way around that. I can get the query formula field to display "09-24-2021 01:45pm; 09-24-2021 4:00pm; 09-24-2021 12:24pm..." and so on. At the end of the day, I want a date/time field that will show me "09-24-2021 12:24pm" as the minimum (earliest) of the three date/times listed above. If I use this formula, it gives me a single date/time, but it's not the earliest one. Min( Part(ToText([FormulaQuery]),1,";"), Part(ToText([FormulaQuery]),2,";"), Part(ToText([FormulaQuery]),3,";"), Part(ToText([FormulaQuery]),4,";")) I can get it to work if I use only the time portion, as that can be converted to a numeric decimal, but that won't work for my purposes since a flight may come in at a later time but an earlier date. Doesn't seem I can take a textlist field, "Part" it, convert it to a date/time, and find the min/max. Am I missing anything? ------------------------------ Michael Frishman ------------------------------
