ContributionsMost RecentMost LikesSolutionsRe: Jinja ISO Date format in PipelineBeautiful solution! Thank you so much! ------------------------------ Jeremy Lahners LeadBaller ------------------------------ Re: Jinja ISO Date format in PipelineHey 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 ------------------------------ Jinja ISO Date format in PipelineHey 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 ------------------------------ Export / filter pipeline activityHi 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 ------------------------------ Background image on code pageHey 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 ------------------------------ Background image on code pageHey 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 ------------------------------ Re: 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 ------------------------------ Re: 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 ------------------------------ Re: Convert timestamp to Date/TimeThank you Prashant - worked perfectly! ------------------------------ Jeremy Lahners LeadBaller ------------------------------ Convert timestamp to Date/TimeHi 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 ------------------------------ Solved