Search found 180 matches

by empmdk
11 Apr 2020, 23:03
Forum: Suggestions
Topic: Files Storage Modules
Replies: 21
Views: 6970

Re: Files Storage Modules

S3 / Wasabi compatibility would also be nice to have.
by empmdk
08 Apr 2020, 19:31
Forum: Discussion
Topic: Email Sending Rules Attach PDF?
Replies: 1
Views: 628

Email Sending Rules Attach PDF?

I have a "Templates to Export" set up for generating PDF / printing of invoices. Is it possible to set up an email sending rule that will attach a PDF copy of the invoice when a user adds a new job?
by empmdk
14 Mar 2020, 23:13
Forum: Discussion
Topic: Boolean Checkbox Display Fields Issue
Replies: 1
Views: 506

Boolean Checkbox Display Fields Issue

Using the Boolean Checkbox field & Display Fields Rules, it has the options for Yes & No. Choosing the Yes option in fields rules works properly. Choosing No does not include the value so it has no effect. See attached image.
by empmdk
14 Mar 2020, 22:17
Forum: Discussion
Topic: Display Field Rules Not Working With Multiselect
Replies: 1
Views: 583

Display Field Rules Not Working With Multiselect

I have a Drop-down list with several options & have configured Display Field Rules to change what fields are visible depending on the option picked. I'm trying to change it to a Drop-down Multiselect to allow more than one choice. However, it seems to break all the field rules that I have set. S...
by empmdk
02 Mar 2020, 19:39
Forum: Discussion
Topic: Filter By Date & Status Issue
Replies: 4
Views: 471

Re: Filter By Date & Status Issue

Looks like that was the problem. Noticed there were some users changing the status to Completed as they were making the record, so there was no date updated field. Set status field to view only & using automate actions buttons to change status now.

Thanks.
by empmdk
01 Mar 2020, 20:43
Forum: Discussion
Topic: Filter By Date & Status Issue
Replies: 4
Views: 471

Re: Filter By Date & Status Issue

That's what I was thinking would be accurate. However, we've noticed some records marked "Completed" are being excluded from the results.
by empmdk
01 Mar 2020, 18:21
Forum: Discussion
Topic: Filter By Date & Status Issue
Replies: 4
Views: 471

Filter By Date & Status Issue

I'm having an issue with filtering by date & status for invoicing not pulling all available records. Filtering by Date Added (02/22/20 - 02/28/20) & Status (Completed) will pull 71 records. Filtering by Date Updated (02/22/20 - 02/28/20) & Status (Completed) will pull 82 records. Filteri...
by empmdk
29 Feb 2020, 21:33
Forum: Suggestions
Topic: Input Field Filterable
Replies: 0
Views: 581

Input Field Filterable

There are a few situations where I need to add a filter, but the field required is an "Input Field". It is currently only a searchable field & not available to filters.
Is there a quick edit I could do to enable this?
by empmdk
23 Feb 2020, 01:33
Forum: Discussion
Topic: Invoice Number Add Leading Zeros?
Replies: 4
Views: 695

Re: Invoice Number Add Leading Zeros?

Update: I've used LPAD to insert the leading zeros & moved the prefix to be part of the Static Text by Pattern. MySQL Formula (id with 7 leading digits and "0" being the placeholder for the leading digits.) LPAD([id],7,0) Static Text by Pattern CDJR[636] If anyone sees a flaw in doing ...
by empmdk
23 Feb 2020, 00:38
Forum: Discussion
Topic: Invoice Number Add Leading Zeros?
Replies: 4
Views: 695

Invoice Number Add Leading Zeros?

I've configured my application to generate invoice #'s based on the record ID #. I have the following set up: A MySQL Formula for the invoice number with (CDJR as the prefix) concat('CDJR', [id]) A Static Text by Pattern with [636] which is the ID of the invoice MySQL Formula. This is to make it sea...