Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

1 Neutral

About H1sc

  • Rank

Profile Information

  • Gender
  1. well, maybe I've overstated my understanding of programming. I'll take a look, but both examples seem a little too complicated... If you could elaborate a little more. As for the moment, I should explain I don't have a filemaker server.
  2. Hi guys, problem here. I'm working with a web viewer and I'm familiar with triggering a script from within the web viewer using the fmp:// protocol. But, what I need is kind of the opposite. I have a 2000 records list that I need to display in my webviewer. As one may find, that is lots of html data, what makes my solution very slow. What I want is a webviewer that displays the first records and, when I scroll down (my first option) or I click a button (second option, but also ok) it displays more records. I'm aware that I could do that using the url protocol, calling a script, rewriting the html code for the webviewer, but that seems as a dumb solution So, it's my understanding that javascript can change the html of a webpage (played a little with javascript, but not a master). So, in theory, there is a way for javascritp to append to the end of my <body> the next record I could use the ExecuteSQL function (not the script step) if it worked, but I'm not sure how to do that without hardcoding the change of the webviewer code, and I rather not do that. I'm really hoping I can handle it from the webviewer I have a hard time being brief. What I want is to pass a parameter from the filemaker to javascript to execute its function. Any help will be overwhelmingly appreciated
  3. Thanks for the help, Fitch. I'll surely take a look at the link of sixfriedrice. But, as occurred to me, I am not happy with my pdf. Maybe I'm trying a step too big, but I'm thinking on going deep in html. I want to give the users the best experience ever (their happiness, their money). Could you point me to some direction on that? I was thinking on collapsing parts of the text, linking one part to another, etc.
  4. Fellow developers, a question I must ask (I'm sorry if this seem so unusual; my filemaker development is not the most common) I have a database of paragraphs. The idea being, each paragraph is a record, in a Table named Reference. The whole idea of this database, which has more tables but could work with just one, is to make a manual, a handbook for the company I work for. Let me give a example: we have a specific instruction on how to deal with taxes at importation. We create a record named: taxes at importation, and we related this record to another record in our self-related table (taxes, or importation). So: RecordID_pk FatherID_fk Title R1 1 0 Importation R2 2 1 Taxes at importation the idea is to have a list of related records, with order numbers self-created, all of which I ALREADY HAVE. So our database already does the following: - organize the record relating it to parents - performs searches easily (thanks for fmsearch for that) - easily allows to change parent record - order the records in a unified string -- 01; 01.01; 01.02; 02, etc. My problem is: we have people (trainees) that need to read the whole manual over and over again (because they want to memorize, and they seem to think this is a good way - who can argue?). We have a "create pdf with all records" button, but they insists on reading live material. And there is some point to that. If the person is reading a theme, and it changes after the PDF is created, it obviously wont go to the pdf (unless another pdf is made). I know that whatever was read before will not be revised (like, any changes in chapter one will be missed if the person is already in chapter two) but he will re-read it eventually; no big deal. As the reading may be exausting, and the trainees have, obviously, other tasks to do, we have a 1000 pages manual, which is something like 60 hours long to read, which the trainees will read 2 hours a day (more or less), 4 days a week. This means that if the trainee generates the PDF today, and we have a change in some topic, he will have to read the whole manual once (60hours/8hours per week aprox = 7,5 weeks) and them re-read the theme, which can cause some stress in this almost two months delay. So, we need to do live reading. My problem is: how to make the best reading experience in filemaker for lots of records with different sizes of text? Some paragraphs are two sentences long. Some, two pages long. Some are just titles. When I print to pdf is very simple (with the slide up feature), but when I make a layout, all I can offer, so far, is a list view with fixed sizes or a form view, with go to next record. What I want? First, any suggestion if there is some obvious way to do what I need that I'm missing Second, a way to display all (or some at least) of my records in a list-way in a webviewer. Kind like a wikipedia page has sub-topics (ok, it doesn't need all the fancy jump-to-section, although it would be awesome). Right now, I'm not trying to have the full-implementation, but just to understand which way I may/might follow. Thanks for the help in reading all this long text. Ps: If necessary, I'd be willing to do some html trick or something like (it already has some html tricks in the webviewer)
  5. Why don't you create a layout based on a table with no fields, that, on layout enter, delete all records from the table without dialog confirmation?
  6. I'm sorry, I think I didn't notice the need of a follow-up. I can do in a way as to avoid tie/gaps (maybe with script). I'll take a look at the attachment soon (headache now). Thanks for all the help so far.
  7. You are awesome!!! I had like a 40 steps script for doing that, and you did it with one calc and one t.o. By the way, I had already related it by ID before. Made the mistake before, but when I came to ask it was alright. If it's not too much to ask, I'd like to know if an upgrade would be possible (seriously, I already think it's awesome). Would it be possible to not repeat a number. Ex: I have two records ranked as 1 with the same parent, they would have the same cParaNum. Could it be that the calculation understood that one would be treated as 1,01 and the other as 1,02? thanks for all the help so far!!
  8. Ideally, if both ways were easy to describe, I'd like to know both. But, for now, I want to ignore the found sets.
  9. Hello, I have a problem of speed on a database that I'd really like some help with. I have a table of topics. Each topic is related to another topic in a parent-son relationship. Example: Topic: Father: filemaker pro 1 (my code for father-of-all) complex calculation filemaker pro custom functions filemaker pro balsamiq mockups 1 features balsamiq mockups price balsamiq mockups what I need to do is to make them ordered in a way such as: 1. Filemaker pro 1.1. Complex Calculations 1.2. Custom Functions 2. Balsamiq mockups 2.1. price 2.2. features I'm able to do the order_number, but in a so slow way. I have for now 800 topics, and it takes like 16 seconds. As I have to do it a lot of times a day (every time someone adds a topic, or wants it to be in a different order, I have to reorder), I'd like to have a faster implementation Can someone help me on what the ideal implementation should be? I'd love if it was fmp, but it'd be fine in pseudo-scripting. thanks for all the help.
  10. As I've been marveled at the little size of my knowledge and at the willingness to help available in this forum, I'd like to make a simple question that, although not totally fmp, is going to help on it. I have a database of read articles. My articles are stored completely, and I highlight portions of them. "Comment", from this forum, helped my way out on implementing background color in it, using a GetAsCss (full link: http://fmforums.com/forum/topic/90644-workflow-fromtext-color-to-highlighted-background-incl-print/), and it was amazing, but I want one more thing yet. I'd like to know what is the easiest way to highlight something in a usable way to fmp. When I was unfamiliar with databases, and stored my articles as pdfs, I used to highlight them on uPad for iPad (which is very useful, btw). But, now, this solution does not fit my needs anymore, as I store my articles in a database. What I want, in short, is to know the best way to highlight something. In fmp, I made some scripts that change the color of the selected text (which work pretty well), but I would get Repetitive strain injury from all the click, select, cmd+1. In the iPad, I could use a stylus and just use it as a pen. What I thought would be possible is some sort of app that allowed me to easily tag parts of a .doc or .txt. Then, I could import it to fmp and script it to make as I'd like. But is there an app for that? Outline for iPad does a great job on the highlighting (you draw a line, it identifies the words selected and highlight it), but it doesn't meet my needs, specially considering that it doesn't support my full articles. Idea was to read on the go in the iPad and later put all in the fmp. Maybe I couldn't make myself clear. I have the scripts to change the selection, or to tag, or to do anything I want with a mouse and keyboard. What I'd like is a way to apply the script in the iPad (maybe there is something in fmgo that I'm missing), in a more easy-to-use way (like, pass the stylus/finger over and it gets the correct tags. thanks for all the help and attention.
  11. It's really quite simple to implement. I cannot state how much I thank you for all the help!! That will do it!! Thanks!!!
  12. yes, it sure was redundant. It's just that I didn't know a better way to do. I'll definitely take a look at GetAsCSS and GetAsSVG. Thanks a thousand times!!
  13. Dear comment, I appreciate all the help, but I still have one question more: what is this in this file? Why isn't that exactly what I'm looking for!!?? Amazing, but, serious, I need a little info about what this is! Totally Amazing!! - Be right back with a lot of questions. By the way, about embedding code, I already thought about doing it error prone (although not that easy). Once I selected some text, I changed it's color and added the keys before and after, all with script. It worked fine.
  14. Well, I'm not a super-user, but I think I understand what you mean. But, if I'm going outside of Filemaker and, as I said, I'm the developer and only user, wouldn't it be a lot easier if I just scripted my way out? I mean, if I made custom tags in filemaker (like [[lb]] and [[/lb]]), and then I just made a conversion tool, to change the [[lb]] to whatever it needs to be in XML/HTML etc? Also, I know almost nothing of XML, and just a little about HTML. Do you think XML would be easier for the re-tagging and printing? I think I could do all the script in fmp (create one table with one global field just for that, which would receive all the content I want to print, all tagged as XML/HTML needs), and then put it some place to print. I know I've probably gone a little far from fmp, but what would be the best way to print them? Html2PDF is you recommendation? Thanks for all the help so far
  15. I'm sorry, I'll try to make myself clear. But I didn't understand what you mean by "the highlight is" 1) "part of the article's description" or 2) "tracked by solution." Just trying to explain myself better with a example: I'll read an article about FileMaker, the article from wikipedia about it (http://en.wikipedia.org/wiki/FileMaker). At first, I'd put it in my articles-to-read list (create a record in my Article's Table, which has the fields ArticleID_pk, FullText, Author, Date, etc). When I find the time to read, I'd highlight the important words of the article. Using the first paragraph of the wikipedia's article: (The highlight will be represent by color changing) FileMaker Pro is a cross-platform relational database application from FileMaker Inc., formerly Claris, a subsidiary of Apple Inc. It integrates a database engine with a GUI-based interface, allowing users to modify the database by dragging new elements into layouts, screens, or forms. Current versions are: FileMaker Pro 13, FileMaker Pro Advanced 13, FileMaker Server 13, and FileMaker Go 13 for iPhone and iPad. This would be a example of a paragraph with highlighted portions. And there would be dozens of paragraphs in an article, and hundreds of articles in my database. Maybe showing what I already have is useful too: I have some scripts that help me in my highlighting. For now, I select a portion of the text with the mouse and press command+1 for activating the script that takes the content of actual field, divide it in three (before, selection and after) modifies the selection and regroup them all, and sets field to it (works pretty well, and with any field). With the fact that I'm the developer and only user, I let with the modified text (for the time being it modifies the color, just for visual help) a pair of tags, like [[lb]] and [[/lb]], for texts that will have, now, light blue color, but that, if possible, would in the future be modified to show a light blue highlight. My question about html (if impossible in fmp, which would really be the best) is due to the fact that, having already tagged the content, and being it so easy, as I would print all my articles (yes, all of them) not that often (like, 6-8 times a year), I could do a script to make a full text (hundreds of pages), and print in some place that allows me to have my background color (like, changing my tags to proper html tags with scripting. thanks very much for the attention, patience and help so far.
  • Create New...

Important Information

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