sal88

Thanks guys! I'll be exploring both options. I guess the new While function will be handy for comment's trimming option too.

Thanks comment!

Ah I must be a bit confused. Basically I have a photo container field that pertains to each user. If the user doesn't have a photo then the I want their initials displayed instead. I've so far achieved this by creating a calculation field with the following calc: If ( IsEmpty ( photo ) ; Left ( Forename ; 1) & Left ( Surname ; 1 ) ; photo ) This works great, and I can add colour to the background by specifying it as the fill of field object in the layout. However I end up getting bits of that colour around the outside of the field if it is populated with a photo. Also it would be nice to be able to specify different colours for each user. So I was wondering if I could bring those extra formatting features to the calculation field. Thanks!

Hi all How can I get my calculated Base64Decode container field to display some centralised (vertically and horiztonally) text, and have the entire background a certain colour? Thanks

Emails are retrieved as records. And the body of the email might contain something like this: Click this link to unsubscribe from this email: https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fmypcsecurity.webrootanywhere.com%2Funsubscribe.aspx%3FT%3Dasdffsdf34228e3b-77d9-4eb2-8132-778fd4dea454%26UEM%3Dsupport%40madso.uk&data=02%7C01%7Cuser@company.com%7Casd29c4c0901c808d673d792d0%7C7a80fada51274aa9aaedca692e314d1d%7C1%xxx68237670672dddata=0YhXOxZRHF6%2Fls6fY%2BA4za%2BvsGo6dPBtWMQhVQZo%2ByE%3D&reserved=0 It's these long strings of text that I would like to remove as they make reading emails difficult (especially when there are multiple emails contacenated). But there are so many different ones that I can only think to do a search by length, rather than a specific substitute calculation.

The string(s) could appear anywhere within the field. I'm trying to clean up emails where there's lots of strings from hyperlinks that are in the signatures (usually from the email signature).

Hi all Is there a calculation to remove all long text strings (say anything over 20 characters) from text fields? Thanks

Fantastic!!! Thank you very much guys. Very exciting! API has hopefully solved this for everyone. mr_vodka - is there a specific reason that FM should not be used strictly as UI to build off of SQL systems? Is it just pointless? And what sort of UI changes would be made? What happens to calculation fields? Is filemaker able to recreate them but alongside the SQL table? Thanks

Hi all Apologies in advance if this is a vague question, or if it's been extensively documented, but I could do with some basic advice on moving filemaker tables to SQL. In terms of database development, I have only really known FileMaker. We have a 60 table, 25 user FileMaker database which takes care of most if not all of the company's operations. There is now talk of allowing other platforms (such as PowerApps/PowerBI) access to the data. One such reason is other people are interested in making apps/applets that serve specific functions. This would be simple if the data were held on a SQL database. So if all the FileMaker tables were to be moved to SQL, what sort of a task is that in terms of keeping the existing FileMaker gui functioning? Or. is there a simpler way to grant other platforms access to filemaker tables? And of course, what are the downsides? Thanks

Hi guys I'm sending the BE_ExecuteSystemCommand provided by the BaseElements plugin. I get a result back, however there are no carriage returns (which would be displayed if I ran the commadn in cmd.exe). If I copy the result to the clipboard using BE_ClipboardSetText (format CF_Text) then paste the results in to notepad then the carriage returns are there. What character is it using as the carriage return in the first place? Thanks Turns out it is unicode character 10 (line feed / LF). I used the following calc to sort: Substitute ( $cmd; Char ( 10 ) ; ¶ )

This has been resolved with the new version of the plugin.

Are you aware that the temp paths are different on the server? https://fmhelp.filemaker.com/help/16/fmp/en/index.html#page/FMP_Help/paths-in-server-side-scripts.html

Try "BE_Curl_Set_Option ( "BE_CURLOPT_FORCE_STARTTLS" ; True )" before the BE_SMTP_Server step, or remove username and password. Also double check you can send via your smtp server with other means, i.e. Outlook. Or, if the attachment was created by filemaker in the first place, try and manually insert an attachment in to the attachment field and try that.

Have you tried doing away with the export step and just emailing straight from the container fields? BE_SMTP_AddAttachment will allow you to add the container fields instead of file paths.

Thanks I'll take a look! it was on the back burner, but now it looks like we may be embarking on the journey again. Needs a bit of a rethink as to what they're actually after. I'll let you know. Cheers!