Jump to content

atlzbest

Members
  • Content count

    11
  • Joined

  • Last visited

Community Reputation

0 Neutral

About atlzbest

  • Rank
    novice
  1. atlzbest

    how to update field based on another field?

    hehehe...no all i need is to update the comments field being displayed based on where the user is typing (doesnt have any relation to table A's contents but rather which field it is) so if user starts typing in ..say Paragraph (table A field = Paragraph) comments should update saying you have 10 lines for paragraph. get(activefieldname) is enough to find out its Paragraph. user starts typing in Bullets, comments textbox should update saying you have 20 lines for bullets. table B has textareaname | comments ------------------------ Paragraph 10 lines max. Bullets 20 lines max. Table A has ----------- record_id paragraph bullets filename there is no join between the tables since there is nothing to relate.
  2. hi guys, sorry if this is under the wrong section. i've got text fields on a layout linked to table A. i've got a table B that has field names and comments from B. So whenever a user starts typing in "paragraph" text field, i would like a comments field to get updated from table B. i know i can put onModify trigger script. what i dont know is how to select and update the comments field. i can get everything in variables but how do i pull up the record and update the field with it? thanks!
  3. hi guys i've got a single table to which 40 layouts are associated. these are layouts for print ads in different sizes. each layout has 6-9 user editable text areas. i need to display formatting rules for each text area the users can type into and need to display "x number of lines allowed, x characters allowed". the idea is that as user moves to the next text area, the formatting rules window updates and displays the rules for the text area the user is in at the moment. putting in validation checks for fields wouldn't work as the same "Paragraph" field might have 80 characters allowed in one layout and 100 in the other. the rules needs to be associated with layouts, not fields. if i do an onenter trigger for each field, i am looking at putting that in for approx 200 objects. My idea is to use a portal. i was thinking of putting in a table called "rules" with layout name, object name, object rules as fields in it. i would put in calculated fields in the main table for layout and object (objects are not named). i would get the associated rule field contents and display it in the portal. the table idea is basically so that if rule contents need to be changed, there's a single repository to make those changes. the portal will automatically update and display the correct related record based on the main table association. is this the right direction or do i need something else? if it is the right way which requires minimal coding, can anyone elaborate how do i accomplish this? here's a sample of the main table & rule table i had in mind main editor editor_id paragraph paragraph_2 bullet bullet_2 buller_3 address layout (calc) get(layoutName) textarea (calc) get (activefieldname) rules layout name ( = from main) textarea ( = from main) rules thanks!
  4. wow..that was it...thanks a million!
  5. that actually did the trick...it works perfectly on onObjectModify the problem i am having now is how to put the focus back to the field where i was typing so assuming i was typing in a field called Title and the character count was being displayed in Counter...Counter gets populated but it also steals the focus...i dont have named Layout Objects so i cannot use Go to Object and that is not an option since i have approx 35 layouts where i need to implement this...none have named layout objects thanks to the previous developer.. is there any other way to give back the focus to the active field?
  6. Guys, I am having a brain freeze. I'm trying a simple thing as counting the number of characters in a field and displaying it..i've got FM Pro 10 Advanced, ive got a onKeyStroke trigger that fires the script.. the layout has 6-10 fields so i cant name the field, ive tried Length ( Get (ActiveFieldContents) ) ..no good Length ( GetAsText (ActiveFieldContents) ) ..no good and then assigning the value to could someone tell what im missing here... update: ok i solved that part...it was getting it correctly, i was using Set field to display it...changed it to InsertCalculatedResult and that works...but now i have another issue...if i press del, space, it fires off which makes sense but its getting in the way of just simply typing, editing in the field... is there a cleaner approach where as the user is typing, a running character count is displayed...this is vital to the business. thanks!
  7. First off, This product is amazing and has amazing potential! What i'm trying to do is alter the cropImage function so it pulls the image from a container, image has already been uploaded, resize it and put it back in the container. is SM able to retrieve data from containers? i havent seen any sample doing that? thanks atlz
  8. Hi Guys I just started on FM so please excuse me if this is too basic or not even possible. I am modifying an existing FM Pro 7 db in FM 10 adv. There are some 50 layouts with similar fields going into the same table. i need to make small modifications to some fields like changing the default color, default font etc. is there a fast way to do it? i was thinking change it in one layout and copy/paste it (would this break any references to tables/scripts that point to it?) but i also had a question in mind that for future purpose can all layouts point to the same object so if i even make a change in one layout, it gets reflected on all layouts? thanks atlz
  9. well got that one done... though i finally had Fm Pro Advance installed, i logged in as Admin (hold Shift while opening) i also learned you could use script debugger and intercept the startup script to disable all menus.
  10. hi guys, we had a fm pro 7 runtime app in windows developed last year that now needs some modifications in the source. how can i look at the source (scripts, tables) in file maker pro 9? i've tried opening the .USR file, holding shift while opening it and specifying the Admin user..everything just opens the app with the splash screen and all functionality locked out. any help is appreciated. thanks
×

Important Information

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