ContributionsMost RecentMost LikesSolutionsRe: Change Webook date format in JSON POST They're going to retire webhooks as they currently exist, so building it as a pipeline is the way to go anyway. ------------------------------ Jeff Peterson ------------------------------ Re: Change Webook date format in JSON POST If you build this in a pipeline instead of the webhook function, you can use jinja to format the date in the request. https://helpv2.quickbase.com/hc/en-us/articles/4473004144660-Transforming-your-data ------------------------------ Jeff Peterson ------------------------------ Re: Jinja Expression Comparing Now to Now+Hours Not really, it's just for a specific purpose and I wanted to avoid adding more fields to that table. ------------------------------ Jeff Peterson ------------------------------ Jinja Expression Comparing Now to Now+Hours I'm trying to compare the date created (fid1) to the current time, based on a value in KM Tier (fid1481). The pipeline runs without errors but I'm not sure if this syntax is correct. Does this look correct? This should resolve to TRUE if, for example the KM Tier is 1 and it's more than 24 hours past the date created. {% if (fid1481 == 1 and now > fid1 + hours(24)) or (fid1481 == 2 and now > fid1 + hours(72)) or (fid1481 == 3 and now > fid1 + hours(96)) or (fid1481 == 4 and now > fid1 + hours(240)) %} {% endif %} ------------------------------ Jeff Peterson ------------------------------ SolvedRe: Pipelines Jinja Expression for Day of Week Thank you! That's what I was after! ------------------------------ Jeff Peterson ------------------------------ Pipelines Jinja Expression for Day of Week I'm trying to figure out this expression that would return TRUE If the current day is not sunday but I'm having some trouble with the jinja here. {% if (now | weekday) != 6 %} {#TRUE if The current day is NOT Sunday#} {% endif %} I know that first line is wrong, but I'm not clear on what the correct syntax should be. Anyone have any idea? ------------------------------ Jeff Peterson ------------------------------ Re: Unwanted "The QuickBase Team" Email Spam Check that one and submit. ------------------------------ Jeff Peterson ------------------------------ Re: Pipeline Upload gsheet to google doc What's the error you're getting? I'm doing this also and it works for me. The pipeline looks like this: ------------------------------ Jeff Peterson ------------------------------ Re: New problems entering address? This is happening when a record is created via an automation. ------------------------------ Jeff Peterson ------------------------------ Re: New problems entering address? The support solution was to switch the format to 'US' format, but that created this new problem where it won't accept the state abbreviation. ------------------------------ Jeff Peterson ------------------------------