ContributionsMost RecentMost LikesSolutionsRe: UTF-8 in Gmail Channel Eduardo - I had a second so I did a quick check. Looks like you need to convert to Base64 when submitting to the api... so there's probably some testing and research you'll need to do. I haven't dealt with this myself - but this is where I'd start.... What I found - https://developers.google.com/gmail/api/guides/sending - Mail API RFC 2822 (https://datatracker.ietf.org/doc/html/rfc2822) Found this conversion for js -https://github.com/googleapis/google-api-nodejs-client/pull/1088 const utf8Subject = `=?utf-8?B?${Buffer.from(subject).toString('base64')}?=`; doing something similar with jinja/formula field might be possible? dunno. aged stackoverflow suggestion - https://stackoverflow.com/questions/61905243/does-gmail-restful-api-support-sending-of-non-ascii-emails-addresses#:~:text=At%20the%20moment%20of%20this,able%20to%20send%20the%20emails. ------------------------------ joe vandervest ------------------------------ Re: Today +3 formula help try - If( [Projected Start Date]>Today()+days(3),"red","white" ) ------------------------------ joe vandervest ------------------------------ Re: Pipeline to create a Google task? Jenn: I saw no one else responded to this, so I thought I'd humbly submit one possible perspective on a solution. I checked and there is no specific Pipeline channel to access the tasks api. Tasks are not part of the Calendar channel in pipelines either. And as you are likely aware, google has been making significant changes to how some of their apps work with tasks. So here's how I'd likely approach a problem similar to the one you portrayed.. I would use these components for this: QB, Pipelines, and Zapier. Setup: Make sure you adjust your QB tables and fields so that you can store items you may want related to the task. For the purpose of editing the TASK or even deleting it or reassigning it in the future from your app you will certainly want to store the TaskID (object ID) that google assigns it when you create it. You'll need that for future Modify-task or delete-task or mark-complete tasks you may want to push from QB to google. Create a webhook in Zapier that will accept a properly formatted and secured web request from Pipelines. You can then use Zapier's support for Google Tasks and the Google API to push task create, modify, delete functions as you desire. Create a Pipeline that is triggered under approriate data conditions then add the web request from the web request channel to call Zapier and Pass it the appropriate data. IF you get really fancy you can probably figure out how to do this with update FILES and do parsing within zapier as well. Assuming a low volume of incidences; modeling it on a change by change basis will at least get you started. General App Flow Data CHANGE triggers Pipeline. Triggered Pipeline send web-request to target Hook at zapier. Zapier zap is fired, takes the data you give it and starts working. Zapier Google Task zap access your google account and updates/modifies as appropriate (you could use branching in the zap to handle different types of requests) The Google API returns data from the call - e.g. TaskID which Zapier gets back. The zap then updates the source (record or records) with the newly minted TaskID. done I've not used the Task zap myself, but it's likely got the majority of actions covered. While you're in there you could probably do something with a calendar event too if you needed to. Maybe that helps. ------------------------------ joe vandervest ------------------------------ Re: New Form Builder Rules - Where is the bug list? Providing a LINK on the NEW FORM when in form edit mode that takes one to a list of KNOWN BUGS would be helpful to new form designers. This would help them decide if the new form is useful in the context they are creating or not. It would also save significant troubleshooting, consternation, and ultimately product frustration because it helps form editors save time figuring out why an expected behavior isn't happening. ------------------------------ joe vandervest ------------------------------ Re: Form rule to populate a date field Hi, to test for NULLS you can use the formula section of the new UI rules definition to test about anything - as long as it TESTS to a Boolean result. You can then have a RULE trigger when the result of your test is TRUE. (e.g. test for NULL or UNSET fields). It's ugly I know. But a work around. That's how I got it to work. Another trick I did was just add a dummy field to the table, don't put it on a form, keep it unset and then test against it in your rules. (Again, ugly, but it works. ) https://community.quickbase.com/discussion/new-forms-rules-test-for-null-or-unset-dates ------------------------------ joe vandervest ------------------------------ Re: How to allow my users to sign into my real with our Google Workspace accounts (SAML) Hi Matt: It's a bit tricky. You need to enable the SAML definition for the group or OU in google via the google admin console where and for whom you want to use it. Once that was configured I was still getting errors. It has something to do with the Return URL that is configured on the QB side. It is BEST to make an appt with QB support once you get it properly setup on the Google side. I was getting pretty frustrated too -- but working with the support engineer at Quick Base we were able to get it figured out just fine. There was some thing that had to do with one of the URL constructs in the QB definition side. It's now working just fine and been working without a flaw for months and months. Cheers. ------------------------------ joe vandervest ------------------------------ Re: New Forms - limited form rules Totally Agree with you! Lack of EDIT is a MAJOR issue! Also - a few triggers that we had before are missing. An EXPORT feature like the pipelines YAML files could be useful. too. One thing/area that might be useful would be to explore the formula builder - from what I gather the results of the formula must be a boolean, and if TRUE the RULE ACTION kicks in, if FALSE it doesn't execute. You might be able to do complex comparisons and tests using it. NOTE -- as far as i can see - there is NO way to access to prior field value for any value that changed in the form session. ------------------------------ joe vandervest ------------------------------ Re: Power Automate to Quickbase Connection? Hi Thomas, I've used third party tools frequently to supplement pipelines - where it's not yet capable of easily supporting what i need. I went and seached and found this pay webservice that seems able to do file conversions with simple webrequests.. .. how to handle the return file in pipelines is beyond me, but if was i trying to do this, I might check out this service - https://www.convertapi.com/ms-office-api - it's an API that will convert formats for you based on web request parameters -- likely something you could push via a pipeline webrequest. ------------------------------ joe vandervest ------------------------------ Re: Audit/View Pipelines that Trigger on a Table? yes - and creative use of tagging - important things to implement BEFORE you start building pipelines - they have a habit of replicating faster than mice upvote this feedback i found - https://feedback.quickbase.com/app/#/case/227118 ------------------------------ joe vandervest ------------------------------ Re: Audit/View Pipelines that Trigger on a Table? upvote this feedback element - https://feedback.quickbase.com/app/#/case/227118 ------------------------------ joe vandervest ------------------------------