Jump to content

Tpaairman

Members
  • Content count

    55
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Tpaairman

  • Rank
    member

Profile Information

  • Gender
    Not Telling

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Tpaairman

    Related data all in one field

    My apologies on over simplifying the field names. In the mean time however, it works quite well. In the interest of keeping things a bit tidy, instead of adding another field, wouldn't this work as well: Substitute ( List (Day ( Child::Somefield )) ; ¶ ; " " )
  2. Tpaairman

    Related data all in one field

    I have two tables, well say Table 1 and Table 2. Table 1 has Field A and Field B, Table 2 also has Field A, which is used to relate to Table 1. On Table 2, I can have a portal with Field B in it (from Table 1) but the problem in this case is it would be very helpful to be able to see several portals at once. But Field B only contains 1 or 2 digit numbers. So what I was wanting to do in the layout for Table 2 is have Field A and well say Field C, and just view as a list. Field C would have all of the related values from Table 1 that match. So the data would look something like this: 2 17 5 14 32 8 In other words, Field C is taking the place of the portal, and showing all of the related data in a line instead of like a list.
  3. ​I've updated the OS (I thought that had been done) however my version of FMP is 10, which is not an options, so Other it is.
  4. ​I did have the script go to that layout then insert the date, but in any event I changed it over to the set field step and it's working. Thank You.
  5. Not sure where else to put this, so here it goes. This is FMP 10, but the problem seems very straight forward. I have a series of number fields, and a date field. As part of my other functions in this table, I need FMP to simply enter the current date in that Date field. I have a startup script that FMP runs when it starts the file, and there rest of it runs as it should. But for some reason, when it gets to this part it puts the date in one of the number fields. I have triple checked, and checked again that the script is set to put it in the right field (it is only one step anyway) but for some reason it just won't go to the correct field. I've read elsewhere that insert a result script steps are not really recommended these days, but I'm not sure how else to go about this one.
  6. Tpaairman

    Sorting a value list

    Thanks for the replies. I've been away from this for a bit, so I will give them a try. @Comment - about the 36 balls, you are correct. Should be 53. The 36 figure stuck in my head from the pick 5 game.
  7. Tpaairman

    Sorting a value list

    Not sure where to ask this one, so here it is. This one is for fun - tracking lottery numbers. I've got a file that I've entered every lottery draw in the state since it started (the list is downloadable online and I was able to import it to FMP). Here's the problem. (And it's not a huge deal but since I can't figure it out, it has become a challenge). The list shows the balls for each draw in the order they were drawn, not numerical order. In other words out of 53 balls, let's say tonight they were drawn as follows: 7, 53, 24, 16, 10, 40. My file has 6 ball fields labeled One, Two, Three, Four, Five and Six - I spelled them out since numbers get messy in calculations. So the list imported so that One = 07, Two = 53 and so on (using my numbers picked above.) Keep in mind it does have leading zeros (7 is listed as 07, not 7). I did come up with a calculation field that is One & Two & Three & Four & Five & Six, so it combines them into one string, but I don't know how to sort the string so the numbers are in order. It doesn't need to change the values of the individual ball fields. I tried creating a value list with the numbers 01-36, and have it based on the values entered in that combined string, but they are still in the same order as entered. So, how can I create a field that will arrange the numbers in numerical order, instead of order of the fields? Keep in mind, I don't care if there is a space between the numbers or if they are all run together as one string.
  8. Tpaairman

    <Index ?

    I have a finances file that has a check register, and a budgeting page. Each has it's own table. Each budget period is 2 weeks long, so there is a record for every budget period. There is also a field on the budget page called Remaining Funds that shows how much money is left after all the budgeted items are paid. I have the same field on the check register page via a relation. It had been working perfectly fine, however I've made some major updates to the whole file, and now it's not working. In browse mode, the field on the check register side just say <Index But the relation and it's key fields on both ends are still working. Here's how it's set up. Each budget record has a start date and end date fields, showing the first and last dates of each budget period. There is also a current date field. As part of the startup script, FMP inserts the current date each time the file is opened. There is a key field, with a calculation, and if the current date falls within the start and end dates, or is equal to either one, the result is a Y, otherwise it's an N. This part is all working perfectly. Meanwhile on the check register side, there is a key field that is a calculation that just equals Y. It's always Y, no matter what. The two key fields are related on the relations part of the define database. And the remaining funds field shows up on the check register page via that relationship. Both key fields are generating what they should, and none of my changes were to the fields that the key looks at in the calculation. So, what stupid, simple thing am I overlooking?
  9. Tpaairman

    script step to change the aligment of a text field: possible?

    I don't think there's a specific script step to do this, but I'm assuming you only want one of three possible alignments - left, center, and right? If that's the case, create three separate fields, one called left, one called center, and one called right. Then format their text respectively, and lay them one on top of each other. As far as how to get your text in the fields, I don't know if you are typing into those fields, or if it is auto entered based on other fields. If it's typing then, In your script add the steps to clear each of the fields: Clear Clear Clear Then in the script it can insert text into the field that corresponds to the alignment you want, or go to that field to be typed into. If it's auto enter, you may need to use an IF: IF [Object = A] Insert text [Left; blah blah blah] Esle IF [Object = B] etc then be sure to add End IF If it's automatically entering the info based on what's in other fields, then instead of the above steps, do this: make each of those alignment fields a calculation, and put in the following: Case (Object = A ; "blah blah blah" ; "" ) Just redo each one for it's correct info. In case your not familiar with the case statement, here's how it works. Notice each section is separated by a ; - you have 3 parts, and those are test, result and default result. The first part (Object = A) is the test. It's checking to see if what's in that field is A. If it is, then the next section kicks in, the result. That is the "blah blah blah" part. So if the contents of your object field is A, then this field will come up as blah blah blah, otherwise it will move on to the default result, which is "". That will make this field blank. You can have as many tests and results as you want with a case statement - we only need one here, but if you wanted more it's just simply test ; result ; test ; result ; test ; result ; default result So it will do the first test and if it's true, then it will use that result, otherwise it will move on to the next test and so on. If it gets to the end and none of the tests were true, it will put in the default result.
  10. Tpaairman

    Print date

    As part of your script, just before the script actually prints the record, add the step to insert the current date, and select the date field. Keep in mind this will change the date each time you go to print that invoice, which I think is what you were asking. If you want it to only put in the date the very first time it's printed, but never change it, then add the following steps just before the actual print step in the script: If [Date] = "" Insert Current Date [Date] End if
  11. Tpaairman

    typing tabs from a script

    I'm not sure about issuing the tab character, but as far as typing form a script - I'm not sure I understand exactly what you are asking, but if you are referring to having the script go to a field and then let you type in that field, then yes. All you have to do is have it go to the field you want to type into, then tell the scrip to Pause Script. After you type, you just hit enter or return and the script continues.
  12. Tpaairman

    Can't Delete - Related Tables Missing

    The only thing that comes to mind right off is to go to the relations screen under manage database and see if the tables are in fact still there, and that the relations are still connected. If you have been making changes to the database itself and maybe deleted a table???
  13. Tpaairman

    extract numbers

    Thanks for the replys Yes. Excuse me that I get hung up on something once in a while. That's why I didn't put expert.
  14. I have a field that is for distances. The data gets imported from a non FMP database. The other DB puts Mil at the end (for miles) so 100 miles shows up as 100 Mil (space and Mil - 4 characters). I need to lop off the Mil at the end. I was going to use a script, and use the set field, and I was thinking it would be something like Left (text) or Right (text) kind of thing, but neither seems to fit, because I could have any number of characters before the Mil (1 mile or 1000 miles)
  15. Tpaairman

    Formatting a number field in a dialog box

    That won't work - I've already done this. The problem is that even though you format the number, FMP still sees the raw data - the format is just to make it easer for you to read. When you format the number, it only formats that one field. The field in the text box is a separate field, even though technically it's the same one from the table. The format does not carry over. I'll give the global text a try and see what happens.
×

Important Information

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