ContributionsMost RecentMost LikesSolutionsTriggering Note Field Update with PipelineHello: Just starting to use Pipelines. On my initial effort, I would like to trigger a text - multi-line entry based on a [Status Field] change. Example: If [Status] changes from "Hold" to "In Progress" make entry in [Installation Notes] = User "Updated Status to In Progress." I know this is simple, but I am just getting going. Dirk ------------------------------ Dirk Ruana ------------------------------ Re: Can I show traffic light status from multiple choice field?Mark: I had read somewhere on here to use Formula Text. Converting to Rich Text Formula solved the issue. Thank you, Dirk ------------------------------ Dirk Ruana ------------------------------ Re: Can I show traffic light status from multiple choice field?I have been able to modify this formula, but the displayed result is hyperlink to the image file, and not the image. I am just trying to display traffic light red, orange, yellow, or green dot. Dirk ------------------------------ Dirk Ruana ------------------------------ Re: Exact Forms PlusWorked Perfect. Never even thought about MS Word option. Thank you, Dirk ------------------------------ Dirk Ruana ------------------------------ Exact Forms PlusHello: I am just trying to create a date stamp on an Exact Forms Plus document. Simply the date that document was created. Trying to determine the right format. I know there is the [EF PDF Date] field, but that is created as the document is generated and does not appear/post on the new Exact Forms PDF. I've tried ~Now ()~, but that is incorrect. What am I doing wrong? Dirk ------------------------------ Dirk Ruana ------------------------------ Many-To-Many relationships Greetings: Each day, I have the daily task of reconciling a log provided by our client against records in my Quickbase App. I basically want to update client provided log (and only those records) with status information captured in Quickbase App. From what I have been able to glean, my best option is to create a Many-to-Many relationship by creating an additional table. I guess I am having trouble visualizing how this relationship would work. I have had prior success with relational databases (just create a relationship one [Work Order Number] field in both tables. My master table [Work Orders] has a Key ID field (which we use for master transaction identifier – So it cannot change). But we do also have a [Work Order Number] filed that should relate to [Work Order Number] on client table. ------------------------------ Dirk Ruana ------------------------------ Automating Exact Forms Plus ButtonHello: I am looking to create a button to automate an Exact Forms Plus button (when a new record is created or saved). Any ideas how I might proceed? Thank you, Dirk ------------------------------ Dirk Ruana ------------------------------ Conditional Counting of Field SummaryWorking of a Work Ticket System and need to the number of days on a ticket that miles driven over 20. Each ticket will most likely have several mileage entries per day. I am not sure if I can use a summary report. But this would be the basic idea: Labor Date Mileage Driven 02/11/2021 30 02/12/2021 19 02/14/2021 46 02/15/2021 60 02/16/2021 15 02/17/2021 21 02/18/2021 23 [Count of Days with Miles Over 20] = 5 I really just need the final results [Count of Days with Miles Over 20]. Any guidance provided would be appreciated. :) ------------------------------ Dirk Ruana ------------------------------ Re: Hour Calculation Hey Mark: Sorry to be such a bother. It is the: Shared Services – App Work Order Table – Table Response Deadline – Filed (Date/Time Formula). Do I need to send you an invite to App? Dirk DirkRuana Superintendent Mobile: 206-375-3544 | Main: 206-682-3030 | Fax: 206-682-6627 Dirk.Ruana@schuchart.com www.schuchart.com ___________________________________________________________________ Schuchart ● 919 5th Avenue ● Seattle ● WA ● 98164 The information transmitted, including attachments, is intended only for the person(s) or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and destroy any copies of this information. Re: Hour CalculationHi Mark It's blank. Dirk ------------------------------ Dirk Ruana ------------------------------