jgrunschel

Nevermind. I see what I did wrong. I need to add the TestInt outside of the Day() or Month() or Year() function.

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 + TestInt ) ; Year ( d ) ) ; TestIntTimeID = 2 ; Date ( Month ( d ) ; Day ( d + ( TestInt * 7 ) ) ; Year ( d ) ) ; TestIntTimeID = 3 ; Date ( Month ( d + TestInt ) ; Day ( d ) ; Year ( d ) ) ; TestIntTimeID = 4 ; Date ( Month ( d ) ; Day ( d ) ; Year ( d + TestInt ) ) ; ) ) Where d is set to a specific date, TestIntTimeID is the ID from the pop-up menu (pertaining to a specific time interval), and TestInt is the amount of time to be added. In this situation, the following time intervals are available: +----+--------------+ | ID | TimeInterval | +----+--------------+ | 1 | Days | | 2 | Weeks | | 3 | Months | | 4 | Years | +----+--------------+ Thanks!

Awesome! Worked like a charm: FieldNames ( Get ( FileName ) ; Get ( LayoutTableName ) )

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.

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!

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.

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 a trailing summary layout part, so they are tacked on after the results. So, I was thinking about putting the buttons in a footer part. That way, they are always visible no matter how many "results" are shown. Also, a footer would allow me to use a fixed window height.

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 ) ) So, if the found count is huge, then the window's height will also be huge, which is why I included the Case statement. However, I'm very new at this, so maybe I'm missing something.

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" through the results (like Google results). I've thought about using [Get ( RecordNumber )], [Get ( FoundCount )], the [Mod ()] function, and a global field holding the current "page" number to only show the records for each "page" (Page 1: Records 1-10; Page 2: Records 11-20; etc.). However, I'm at a total loss as to how to modify the find (Constrain/Extend Found Set) to show only the appropriate records. I've also thought about using a self Join with a tab control and a portal on each tab with each portal starting row different. This limits the number of "pages" to whatever the number of tabs would be. I've attached a picture with the "page" details hard-coded into the layout, just to convey my idea. Hopefully, everything I've said makes sense.

*sigh* I was afraid of that. Okay. Thanks.

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 think it would work very well, as I'm showing the results of a find.

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".

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 return and escape keys. "Return" is supposed to be like clicking the "Search" button and "Escape" like clicking the "Cancel" button. Clicking the "Search" button works fine, but pressing "Enter" seems to continue the paused script, such that, when the results are displayed, the window is no longer "modal". Hopefully my explanation makes sense, but I've also attached a lean version of my database to play with. Thanks for any advice or help you can give. ScriptTriggerProblem.zip

Awesome! That is exactly what I was looking for! I guess I should learn more about CSS. Anyway, thanks a bunch! :yourock:

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.