Ron Cates

Members
  • Content count

    550
  • Joined

  • Last visited

  • Days Won

    2

Ron Cates last won the day on September 6 2012

Ron Cates had the most liked content!

Community Reputation

8 Neutral

About Ron Cates

  • Rank
    member
  • Birthday 04/07/1969

Profile Information

  • Gender
    Male
  • Location
    Morristown TN ( Near Knoxville )

Contact Methods

  • MSN
    ron.cates@hotmail.com

FIleMaker Profile

  • FM Application
    14 Advanced
  • Platform
    Windows 10
  • Skill Level
    Intermediate
  • Membership
    TechNet
  1. Thanks Comment. I was able to use GtAsCSS to detect styling. I'm experiencing a strange behavior now though. When I apply a text style using TextStyleAdd ( Middle ( Get ( ActiveFieldContents ) ; Get ( ActiveSelectionStart ) ; Get ( ActiveSelectionSize ) ) ; Bold ) the highlighted text becomes Bold as desired. Then with the same newly bold text highlighted and using TextStyleRemove ( Middle ( Get ( ActiveFieldContents ) ; Get ( ActiveSelectionStart ) ; Get ( ActiveSelectionSize ) ) ; Bold ) The Bold styling is not removed. However if I select the same text and include one or more preceding unbolded characters it then removes the Bold style.
  2. Is there any way to detect if formatting is already applied? For instance, if highlighted text is already bold I would like to be able to unbold the text? Trying to approximate known text editing behavior as much as possible.
  3. And there it is. Thank you
  4. I'm working on a merge letter type interface. I have a list of merge field choices in a portal next to a text field. I would like to be able to insert into the text field when clicking on a button on the portal row. But I just realized when clicking a button in a portal it pulls the cursor out of the currently active field since I'm actually selecting a related record. Thus Insert Calculated Results will not work to insert the merge field name at the current cursor position. Any suggestions on how to work around this issue?
  5. Hi all. I am about to start building a user interface to provide text formatting functionality whereby users can format text using buttons I have provided such as Bold, Italic, and so on. Basically buttons for all the text formatting functions FileMaker provides. I specifically need the ability for users to be able to highlight text within a block of text in a text field and add formatting to the highlighted text. Can anyone recommend a source with some examples or video tutorials on how to accomplish this. Thanks in advance
  6. Hi All. I am trying to do a scripted import using PSOS. The import is importing from one table in my file to another. The source table is a table occurrence in the current file with an external data source from another file hosted on the same server. It fails with an error of 100 file missing Is this not possible with PSOS? I saw where PSOS could only import from the documents folder on the server but I wasn't sure if that also eliminated importing from one table to another in the same file. Just wanting to know if it's just not doable or if there is something else I should be looking for?
  7. Somehow I can't imagine Comment was ever new...
  8. I'm trying to wrap my head around using ExecuteSQL() to produce the following results but I could use some help. I have a table of projects with a field for status. I would like to query the table to get a list of all the statuses and how many projects contain each status. Active,10 Inactive,15 Cancelled,2 Completed,25
  9. I did catch that. Probably should have edited the post...
  10. I ran into this problem for a long time with a solution I was working with. It seemed the field or other objects would shift by a half a point when I selected them. In the end the behavior seemed to be due to having lines on the object that were les than a full point. For instance a field with .25 or .5 lines around it. When I switched to full point lines it stopped.
  11. Guess I'll just have to do it the hard way. Lol! ExecuteSQL ( " SELECT FieldName FROM FileMaker_Fields WHERE TableName = ? AND ( AND FieldName NOT LIKE ? AND FieldName NOT LIKE ? AND FieldName NOT LIKE ? AND FieldName NOT LIKE ? AND FieldName NOT LIKE ? AND FieldName NOT LIKE ? AND FieldName NOT LIKE ? AND FieldName NOT LIKE ? AND FieldName NOT LIKE ? AND FieldName NOT LIKE ? AND FieldName NOT LIKE ? AND FieldName NOT LIKE ? AND FieldName NOT LIKE ? AND FieldName NOT LIKE ? AND FieldName NOT LIKE ? AND FieldName NOT LIKE ? AND FieldName NOT LIKE ? AND FieldName NOT LIKE ? AND FieldName NOT LIKE ? AND FieldName NOT LIKE ? AND FieldName NOT LIKE ? AND FieldName NOT LIKE ? AND FieldName NOT LIKE ? AND FieldName NOT LIKE ? AND FieldName NOT LIKE ? AND FieldName NOT LIKE ? ) " ; "" ; "" ; "Notes" ; "zA%" ; "zB%" ; "zC%" ; "zD%" ; "zE%" ; "zF%" ; "zG%" ; "zH%" ; "zI%" ; "zJ%" ; "zK%" ; "zL%" ; "zM%" ; "zN%" ; "zO%" ; "zP%" ; "zQ%" ; "zR%" ; "zS%" ; "zT%" ; "zU%" ; "zV%" ; "zW%" ; "zX%" ; "zY%" ; "zZ%" )
  12. Thought that might be the case. What about substituting those fields out after the ExecuteSQL(). would that be any easier? How would that look?