Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About jgrunschel

  • Rank
  • Birthday 12/06/1984

Recent Profile Visitors

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

  1. Nevermind. I see what I did wrong. I need to add the TestInt outside of the Day() or Month() or Year() function.
  2. Okay, what happens if the current month is December (i.e., 12). Is the calculation engine smart enough to roll-over to January (1) and increase the year by one? If so, how does one accomplish this, because it's not working for me. For Example, I'm using a Case statement to add to either the month, day, or year depending on what the user chooses from a pop-up. I have the following calculation for the field, but it doesn't seem to be working: Let ( d = Max ( Companies_Plants_Units_Devices_EVENTS::Date ) ; Case ( TestIntTimeID = 1 ; Date ( Month ( d ) ; Day ( d + Test
  3. Awesome! Worked like a charm: FieldNames ( Get ( FileName ) ; Get ( LayoutTableName ) )
  4. Hello, I was wondering if there is a Get function that retrieves the names of all of the fields from a specified table and returns them as a value list. For example lets say you have a table of People with the following fields: ID FirstName LastName Address1 Address2 ... Then, GetFieldNames ( People ) would return: ID FirstName LastName Address1 Address2 ... A custom function could probably do this, but I am not very skilled at writing CFs. I did a really quick search of Brian Dunning's site, but did not see an appropriate CF.
  5. I can see how it wouldn't be the best solution, but I think this is the solution that I'm looking for. Who knows, as the project develops, things often change according to beta testing feedback and such. Thanks for the point in the direction I was looking for!
  6. I feel like we've gone a little off topic, because I don't have any problems with limiting the size of the window. That all works fine. By the way, it is the application window that has the scroll bars. I was just wondering if it were possible to have a layout that shows x number of results per "page". Anyway, thanks for the info.
  7. You are correct. I don't know why Windows does it, but when you resize a window larger than the desktop, or move a window off of the desktop, the desktop grows scroll bars to accommodate. The two screen captures show this phenomenon. The first picture (NoScrollBars.jpg) has the window height cap "on". While the second picture (ScrollBars.jpg) has it "off". I was hoping to get some sort of "pages" results, mainly, because I thought it would be cool. However, it seems like it's not worth the effort. Right now, the "View Selected", "Edit Search" and "Cancel" buttons are part of
  8. Sorry, I went camping over the weekend and was without technology. Anyway. With the way my script is currently written, yes. I get the top, left, height, and width of the "results" window, then use the Move/Resize Window script command. Where the width is a fixed width to match my "results" layout and the height is based off of the FoundCount: Let ( [ x = Get ( FoundCount ) ; h = 20 * x + 171 + ( Get ( WindowHeight ) - Get ( WindowContentHeight ) ) ] ; Case ( h > Get ( WindowDesktopHeight ) ; Get ( WindowDesktopHeight ) - 4 ; h ) )
  9. Hello, Okay, here's the scenario: You're in form view, and press a search button. A little search window pops up (a form). You type your criteria, and the search pop up window changes to show the results of your found set (a list). I have all of this working beautifully. However, the search/results window changes height according to the number of found records. To avoid a ridiculously tall window, I have a cap set to limit the window height to the desktop height [Get ( WindowDesktopHeight )]. In the event of more than 10 found records, I'd like to be able to "page" thro
  10. *sigh* I was afraid of that. Okay. Thanks.
  11. Hello, I remember seeing someone mention this in passing, but I can't seem to find where that was (it might have been on a different site). So, my question is, when you're in list mode, is there a way to hide the little indicator of the current record? I'm using conditional formatting to show the active record and a global field to determine which record to work with, so I feel that the little black bar on the left is distracting and somewhat unprofessional Of course, I could just be displaying my data in a less than ideal way. I've thought about using a portal, but I don't thi
  12. Nevermind. I didn't know that performing a find would cause a paused script to continue. Silly newbie mistake : . Also, I found a much better method for handling my search, by John Mark Osborne, Here, under "Ultimate Find".
  13. Hello, I'm using a pop-up window that enters find mode as a method to search the database. I'm not very fond of pop-up windows, as they can get "lost" if the user accidentally clicks outside of them. So, I'm using the "pause script" script step to make the pop-up "modal". There are two buttons within the pop-up: "Cancel" and "Search". "Cancel" resumes the script and closes the pop-up, while "Search" performs the find and changes the pop-up layout to display the found set as a list. I also have keystroke triggers, set on every field within the search layout, to trap the retur
  14. Awesome! That is exactly what I was looking for! I guess I should learn more about CSS. Anyway, thanks a bunch! :yourock:
  15. Well, you're not actually hiding the scroll bar. It's still there, but the colors are set to blend with the background. The scroll bars (at least for me) take up roughly 18 pixels. So, blending them with the background gives an 18 pixel border on the right and bottom of the web viewer. Like I said, it's not exactly what I was looking for, but I can make it work.
  • Create New...

Important Information

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