HunterBoss

Ryan, What constitutes closed? What if the database is on a server? Have you seen anybody work with a password manager and use an API to get the credentials? Thanks (Also, full disclosure. It's my solution Hannah's working on.)

Within QBOE there's a function or button where the user can create a URL that provides a real time link to that specific invoice. It can be used as a way for the client to pay online. The URL starts with https://connect.intuit.com/portal/app/CommerceNetwork/.... When we first started to try to get data from QBOE, we thought this was possible. Now we're having a hard time finding it. Anybody else try this? Thanks Christopher

QuickBooks Online has taken away some functionality in regards to printing statements for mailing purposes. Yes. We still need to occasionally kill the odd tree or two. Now that we've got all our QBOE data in our FM solution, is there a Statement (as opposed to Invoices) option/layout I've missed? Thanks Christopher

I looked but as I'm searing for a 3 letter phrase, it didn't seem to bring up any results. AOL's instant messaging service is being discontinued as of December 2017. Will there be a new SMS option going forward? Thanks Christopher

Hello The built in chart functions of FM will let us create a bubble chart - basically a scatter graph with 3 data sets. My problem is I'm going to need hundreds of data sets, which is going to result in a lot of overlap. Does anybody know of a solution to this problem? I've looked at 360 Works charts - haven't played with the demo yet - but it doesn't seem like they cover scatter graphs. Thanks in advance. Christopher

I'm having a bit of a hard time finding firms that host FM databases and have only found 2 that provide WebDirect. Anybody got any favorites? I know I need to ultimately ask the vendors this question, but how many connections are allowed? Is it based on the vendor's license or mine? Thanks in advance Christopher

Simon, Still happy with MoneyWorks?

Not sure if we're talking about the same things and since it's 18 months later, maybe things have changed. I know we can send emails and texts from within FM. Can we tweet as well? I was thinking of giving clients the choice of how the want to receive a confirmation. The easy ones are email or text. But then I thought about the possibility of a tweet. Anything? Thanks Christopher (so, of course I manage to finally find someone else's post about this just after I posted this. any first hand experience out there?)

I know that QB and FM can be integrated with at least two different 3rd party plug-ins I've found. The question is - do the plugins work as well with the online version as the desktop version? thanks Christopher

I've sent an email to them and they haven't updated it yet, but said they will soon.

Conditional formatting works with Merge Fields. Right click and select conditional formatting. Add a condition. Make the Condition "Formula is" and just put a 1 in the field to the right of that. Then select your fill color. The fill will be dynamic. That what you're looking for? Christopher

yes

comment That's not true. There are multiple records for multiple transactions in the table. When ever a transaction is edited new record is made. I'm not the source of the data. I use what's sent to me. I need to find out which is the most recent record for different types of fields. Without the sort order there's no way that I know of to find the most recent record(s). So, that being said, I do appreciate your responses, but is there a way to have a calculation that is layout dependent? Fields are only updated/valued/calculated/whatever when a specific layout is active? Christopher

Calculated Field 1 is the client ID number if that record is the most recent active record for that client Calculated Field 2 is the record ID number if that record is active for that client So, on other layouts I may sort by phone number or state or city or county, etc. I need Calculated Fields 1 & 2 not change. This help?

All I'm not sure if I've got a problem or I'm just panicking. I have a layout called "Sorted." I have a specific sort script that I only use on this layout. The table associated with the layout "Sorted" has 3 calculated fields that return values dependent upon the sort results. My problem/question is what happens when I go to other layouts? I'm never going to use the sort script I associate with the layout "Sorted" on other layouts. But, other layouts will be sorted based upon different criteria. So, is there a way to have a calculation only "work" (I'm sure that's the wrong phrase) or calculate based on the layout it is on? I want it to remember the values from the sort on Sorted when I go to a different layout and not recalculate them. I know I can do a script to set the calculated values into an additional field. I was hoping to be able to accomplish this without that. Possible? Thanks Christopher

Does anybody know where the posting above has gone to? The link no longer works and I looked on his site and it doesn't appear to be there anymore. Christopher

David, Thanks I think I saw in another thread that Scribe is only able to write to DOCX Word files in Windows. Is that right? Looks like I'll have a DOCX file set up with the correct formatting and then print that to PDF. If I may hijack my own thread -- I'm wondering if it can do something else I was hoping for. In looking through the website, I think it can. I'm going to have multiple RTF files -- possibly in Super Container -- can I "combine" those multiple RTF files into one PDF in Scribe? No formatting, no find and replace, just simple combine in the right order. Christopher

David So, the replacement part, #2, is right. Right? Can we "send" the text to a Word document that is formatted the way we want? Do we need to have the file in Word already, or can we send the output to Word? Is there something within Scribe that can then turn the Word document into PDF? thanks everyone Christopher

Based on what I've seen on the 360works website and on this forum, I think I can do it. We have a vendor that generates RTF files. We're happy with about 95+% of what comes out of the system. As it's essentially always the same issues, I was thinking Scribe would do the trick. We need to do the following: 1. Start with the RTF file. (These will always be called something different. We can put each RTF in the same subdirectory to make the first part easier.) 2. Replace certain phrases (there will be more than 20) with phrases of our own. As an illustration, but not a real example -- "Thou Shalt" is replaced with "they will" and "Next preceding" is replaced with "earliest possible." 3. The font and size of the font is changed to something else 4. A PDF is created. The name of the PDF is the same as the RTF. It seems like there's more steps then listed above, but this is what we're looking for results. Are my assumptions correct? Thanks Christopher

um, I'm missing something how do you rebuild the database from an empty file if you can't import?

Huh Thanks turns out the sort wasn't on the right field after all. oh well. working now.

How do you find on a summary field? When I go to find mode, I can't enter the field. What am I missing? thanks Christopher

Bruce Can't. Too big. The funny thing is I added 4 more portals all pointing to the same table, but this time they're sorting on different fields. And they're all sorting properly. What can I do in the way of screen shots that would be helpful? Thanks Christopher

I can't get the simplest thing to work. I've got the port set up I'm telling it to sort by an indexed field that contains numbers and is set as "number". But the portal isn't sorting. I've even sorted the table that the portal is based on. No luck. What the heck simple thing am I missing? Thanks Christopher

Julian I've been having the same problems this week. A file that was working without any issues is now crashing several times a day. I thought I'd found a way around that. I made a clone and then started importing into the clone. For about a day I had a nice clean fast database. Now it's crashing again. I'm still in the building phase, so I'm adding fields and calculations and indexing, etc. I'm going to try the recovery option and see if that helps. Anyone else out there got any ideas? Oh, I'm on a brand new Mac Pro running the latest version of 11 thanks Christopher