AnneMartin
Qrew Trainee
Joined 5 years ago
User Profile
User Widgets
Contributions
Pipeline Advanced Query multiple conditions
I have a pipeline I'd like to trigger based on conditions from multiple fields. These conditions work separately but I'm not able to get them to work together. I used the syntax provided on this page: Quickbase Help I need to use a query instead of the built in conditions because the first condition requires 2 date fields to match each other. {35.ex.'_fid_7'}AND{36.ex.'true'} ------------------------------ Anne Martin ------------------------------Re: Formula Query touserlist error
Below is my successful (abbreviated) formula. I'm not familiar with how to get the User ID though. Hope this helps! //list all installers scheduled on this date. convert to email address, then back to user //table ID: _DBID_SCHEDULE, FID 79 = installer email, FID 6 = date var text PullUsers= "{6.EX.'"&[Date]&"'}"; var text UserEmail= ToText( GetFieldValues(GetRecords($PullUsers,[_DBID_SCHEDULE]),79)); var text AllUsers= $UserEmail; var user UserOne= ToUser(Trim(Part($AllUsers,1,";"))); var user UserTwo= ToUser(Trim(Part($AllUsers,2,";"))); .... ToUserList($UserOne, $UserTwo, $UserThree, ...) ------------------------------ Anne Martin ------------------------------Docusign numeric fields
I've built a customer contract form in Docusign and am trying to connect it via piplines. The only problem is, the numeric fields on my Docusign template don't appear as input fields on the pipeline. I converted the fields to text, and am able to input data, but then the calculation fields don't work. ------------------------------ Anne Martin ------------------------------
