Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


OlgerDiekstra last won the day on February 14

OlgerDiekstra had the most liked content!

Community Reputation

26 Excellent

About OlgerDiekstra

  • Rank

Profile Information

  • Title
    FileMaker Developer
  • Gender
  • Location
    Gold Coast, Australia

Contact Methods

  • Website URL

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
  • OS Version

FileMaker Partner

  • Certification

Recent Profile Visitors

8,429 profile views
  1. Maybe display these emails in a webviewer so that the html code gets displayed properly? I did a google on removing urls form emails and got a lot of responses that had negative results from this. Apparently not as easy to do as it has a tendency to break a lot in the emails.
  2. Why not use the FileMaker Data API to allow access? That is the purpose of the API after all, and it saves a lot of time trying to migrate schema and data out of FileMaker, and build ESS structures. v16 has limited functionality so you'd really need v17 for this, but integrations become simple, standard API requests from foreign apps.
  3. I do something similar to receive SMS messages from our SMS provider. Customer can send text messages, which our SMS provider forwards to our FM server. It's basically a post to our server that is processed using PHP. <?php require_once ('FileMaker.php'); #Some sanitization, I know what sort of data I can expect in the various variables. $SMS_to = isset( $_GET['to'] ) ? preg_replace('/[^0-9]/', '', $_GET['to'] ) : ""; $SMS_from = isset( $_GET['from'] ) ? preg_replace('/[^0-9]/', '', $_GET['from'] ) : ""; $SMS_message = isset( $_GET['message'] ) ? preg_replace('/[^a-zA-Z0-9%]/', '', $_GET['message'] ) : ""; $SMS_ref = isset( $_GET['ref'] ) ? preg_replace('/[^0-9]/', '', $_GET['ref'] ) : ""; $fm = new FileMaker(); $fm->setProperty('database', 'Database Name'); $fm->setProperty('hostspec', 'http://localhost'); $fm->setProperty('username', 'username'); $fm->setProperty('password', 'password'); #I built a new parameter line from the provided variables to use when calling my FM log script. Every attempt is logged. $param = ''; foreach( $_GET as $key => $value) { if( $param === "" ) { $param = $param . $key . "=" . $value; } else { $param = $param . "&" . $key . "=" . $value; } } $log = $fm->newPerformScriptCommand('SMSLog', 'SMSBroadcast_Log', $param); $result = $log->execute(); #This is where the real work happens. Checking if all required variables are populated, then invoke the FM script that handles inbound SMS. if( $SMS_to === "" or $SMS_from === "" or $SMS_message === "" ) { if( $SMS_to === "" ) echo 'missing to<br>'; if( $SMS_from === "" ) echo 'missing from<br>'; if( $SMS_message === "" ) echo 'missing message<br>'; } else { $newPerformScript = $fm->newPerformScriptCommand('MSG_Base', 'SMSBroadcast_InboundSMS', $param); $result = $newPerformScript->execute(); echo 'OK'; } ?> All this script does is relay the SMS our SMS provider sends us on to FileMaker. FileMaker then parses the variables and actions however necessary. Maybe that helps?
  4. He seems to have done that. The first screenshot Samarthmkt provided has the popover selected which has the object name applied. I think we need to see the entire script, there may be another go to object or go to field script step that closes the popover. Samarthmkt, have you stepped through the script with the debugger to see where it closes it?
  5. You could also open the file with a fmp url. You can specify the username and password in the url, though that may not be secure enough. Fmp urls are send across in plain text afaik. Once the file is open FM will access that file with user used to open the file. Just to elaborate a bit on this, you could create a user (in the foreign file) with only permission to log in/open (the foreign file), and then do a relogin using credentials stored in your solution to gain the required permissions. This would mitigate the insecurity of logging in to the foreign solution somewhat.
  6. Without seeing the popover layout info, the only thing I can think of is that you've assigned the object name to the popover button, instead of the actual popover. Assuming the object name "SI Printing Details" is supposed to be the name of a popover. Also, you don't need the case statements in the IF's. They serve no purpose. If [ QutSI Products::Print Quote Status = "Yes" ] Works just as well.
  7. Nope. If you were able to change data in the same record another user is currently editing, your data would be over written with the other user's data once they commit. They hold a copy of the record in memory and will over write any changes you made (if it were possible). Luckily, FM prevents this from happening. You do not want multiple users editing the same record. The best approach is to store the id's of records that are locked and revisit them later. Or store them and retry at the end of the run.
  8. I'm not sure about a paused find, but when you use the pause/resume script step, you have to resume with a button that has the option "Resume Current Script" enabled. This might be true for a paused find as well.
  9. I do this to display a gallery of images. I have a 3 panel slide control, where the middle panel has focus. Whilst I use images (ie a container) you could use any field(s) on the panel. The way it works is that you duplicate your normal fields that would show on the middle panel, as global fields, and place those fields on the same location on the left and right panel. When you swipe either left or right, you populate the globals with the data from the next or previous record, allow the panel to slide, freeze the window, go to your next or previous record in the found set, and move the slide control back to the middle panel, ready for the next swipe.
  10. Your post suggests a single machine/user setup. If that is the case, why not simply use the send mail script step with the email client? That functionality is built in which saves you buying a plugin (remember there are also free plugins that may do what you need, such as Base Elements) and you should be able to do that yourself (short script that uses the send mail script step and saves you attachments somewhere for you). Although you could also keep the email/attachment in a folder in your mail client.
  11. A paragraph can contain soft returns (linefeeds), where a sentence within a paragraph starts on a newline, while still being part of the paragraph. Paragraphs generally end with a hard return or paragraph return (wikipedia). HTML for instance wraps text in the <p>...</p> tag indicating a paragraph. This might help: TO count paragraphs using valuecount, you'd first need to replace all the char(10)'s with something else (a space would do) and then use valuecount to calculate the lines.
  12. Ha, I don't have a Mac to play with. Windows only. But you have a point. Refreshing my memory (ie googling) learns that webdings, wingdings etc are not reliable on webpages, and probably also not across platforms. Unicode (which is what Char() produces) is (or supposed to be) reliable on webpages and across platforms. From what I've read, webdings and wingdings (the latter I knew) is geared towards Windows. Other plaforms may have implemented parts or the whole but there's no guarantee. In fact, Web/wingdings displays best in IE. That says enough really. So we're best off to use Char( 61543 ). Thanks Comment!
  13. Cool. Might come in handy sometime. For those interested in this, here's code that will make this work: Place a text object on a layout and give it the value <<$$BG>>, or whatever suits. Use a script with the following code to control the color: Set Variable [$$BG; Value: "g"] Set Variable [$$BG; Value: TextFont( $$BG; "webdings" )] Set Variable [$$BG; Value: TextSize( $$BG; 1000 )] Set Variable [$$BG; Value: TextColor( $$BG; RGB( 128; 128; 128 ) )] Refresh Window [] Size and color can now be set dynamically. These variables can of course be merged into one. Char( 61543 ) that Comment used above is actually "g" in webding.
  14. I thought that was an interesting option and looked into how to apply that. But Textcolor changes the color of the actual text in a field (or variable) not the background. Can you give an example how to color a background ( I assume a text object) using this?
  15. I've found references to a "The Everything Reference 4", is that a more recent version? If not, will the reference ever get an update?
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.