JeremyLahners
Qrew Cadet
Joined 3 years ago
User Profile
User Widgets
Contributions
Re: Jinja ISO Date format in Pipeline
Hey Doug, this definitely got me closer, especially for DateTime fields. Now I am just struggling with separate Date and Time fields. Any suggestions on how to combine a Date and Time field into one datetime object so I can apply strftime() to it? Date: 2023-01-17 Time: 4:00 PM Desired Output: 2023-01-17T16:00:00Z ------------------------------ Jeremy Lahners LeadBaller ------------------------------259Views0likes3CommentsJinja ISO Date format in Pipeline
Hey experts, I am trying to use the value of a field (Date/Time or Date field) in a Pipeline to be sent to a webhook. I need to output an ISO date but can't figure out how to convert it to the right format. Currently I'm getting: 2023-01-16 15:59:19.671000+00:00 I need: 2023-01-16T15:59:19.671Z Is there a Jinja function or something I can use to make this conversion? ------------------------------ Jeremy Lahners LeadBaller ------------------------------222Views0likes5CommentsExport / filter pipeline activity
Hi friends, I have a pipeline that executes a lot throughout the day (roughly 2,000 executions per day). These are triggered by a remote webhook. I need to troubleshoot a few of the executions to see why updates to QuickBase aren't occurring like I expect. Unfortunately I am not seeing errors on these so they must be going through a logic path that I don't expect within the pipeline. In order to research this, I need to find the single execution I'm looking for and am wondering if the community has any suggestions on how to find that "needle in the haystack". I've looked around for an export or filter option but haven't found anything. Does anyone have a solution they could share on how to find the 4-5 problem executions within 2k? Scrolling through the activity feed is unmanageable... Thanks all ------------------------------ Jeremy Lahners LeadBaller ------------------------------4Views0likes0CommentsBackground image on code page
Hey all! We've developed a codepage that our users land on and, for the most part, it works wonderfully. However a small subset of our users are encountering a situation where the background image doesn't display (shows a broken image icon). We haven't identified any obvious similarities between the subset of users (browser, extensions / plugins, etc) that help us identify what is causing the issue. We have a table inside our app called "Images" and we've copied the full path to the image into the code page. Again, for most users, it works perfectly. Does anyone have a better suggestion for how to path that image file so it more consistently shows for our users? Sample code: <img class="my-image" src="https://myrealm.quickbase.com/up/111222333/g/rb/eh/va/myGreatImage.png" /> For clarity, I do have the correct realm in our actual code. Also, the '111222333' is the table ID of the Images table within the app. Suggestions appreciated! ------------------------------ Jeremy Lahners LeadBaller ------------------------------9Views0likes0CommentsBackground image on code page
Hey all! We've developed a codepage that our users land on and, for the most part, it works wonderfully. However a small subset of our users are encountering a situation where the background image doesn't display (shows a broken image icon). We haven't identified any obvious similarities between the subset of users (browser, extensions / plugins, etc) that help us identify what is causing the issue. We have a table inside our app called "Images" and we've copied the full path to the image into the code page. Again, for most users, it works perfectly. Does anyone have a better suggestion for how to path that image file so it more consistently shows for our users? Sample code: <img class="my-image" src="https://myrealm.quickbase.com/up/111222333/g/rb/eh/va/myGreatImage.png" /> For clarity, I do have the correct realm in our actual code. Also, the '111222333' is the table ID of the Images table within the app. Suggestions appreciated! ------------------------------ Jeremy Lahners LeadBaller ------------------------------1View0likes0CommentsRe: 2022 QuickBase REST API Starter Development Kit for PHP.
It looks like it is related to the latest code checkin. In the repo the extra $ is still on line 48. I tracked that down and am getting responses now. Also, I am not using the get_and_set method now, it appears to work without that function call. ------------------------------ Jeremy Lahners LeadBaller ------------------------------12Views0likes1CommentRe: 2022 QuickBase REST API Starter Development Kit for PHP.
Hey Joseph, thanks for this! Super helpful for our WordPress site we are developing. I'm intending on using this in a couple shortcodes and am hitting an unexpected error. A snippet of my code: $QuickBaseAPI = new QuickBaseRestAPI($user_token, $app_token, $realm, $user_agent); $QuickBaseAPI->get_and_set_temporary_access_token($query_table); $video_url = $QuickBaseAPI->query_for_data($query_table, $select , $where); $user_token and $user_agent are empty strings. I added get_and_set_temporary_access_token because I was getting an error in query_for_data saying the access_token was empty. Now I'm getting a "Bad Request" inside of get_and_set_temporary_access_token from line 91. Any suggestions on what might be awry here? Happy to share more code if needed. ------------------------------ Jeremy Lahners LeadBaller ------------------------------6Views0likes3CommentsConvert timestamp to Date/Time
Hi friends! I am trying to convert a timestamp over to a Date/Time field and am failing miserably. I have a text string that am I am extracting elements from using multiple formula fields, one of which is the intended Date/Time field. I have all the other text fields working just fine but can't get the formatting right on the Date/Time. A snippet of the text I receive is: {"owner":"frank@example.com","leadsource":"leadballer","time":"2022-08-11T13:18:08+00:00","type":"InvitationAccepted", ... I can easily get that converted to text via a Formula-Text field and the formula: var number start = Find([Original JSON], "\"time\":\""); var number end = Find([Original JSON], "\",\"type\""); var number startlength = Length("\"time\":\""); Mid([Original JSON], $start+$startlength,$end-$start-$startlength) However, when I change over to a Formula-DateTime field and try to use ToTimestamp or other type conversions, it fails and I get a blank result. Any suggestions on how to convert "2022-08-11T13:18:08+00:00" to a Date/Time? ------------------------------ Jeremy Lahners LeadBaller ------------------------------Solved42Views0likes2Comments