DblWide

I had the same problem...I have a portal in IWP and it would not automatically create a new row. I placed a button on the row that would call the "add portal row" script. The script Ugo DI LUCA gave us worked beautifully! Thanks!

I want to create an A-Z navigation bar that will allow users to "jump to" a record in the found set, based on the first letter of the <> field. The purpose of the nav bar is so that users can avoid scrolling through lots of records, or typing in criteria for finds. I envision it looking like this: A | B | C | D |... |XYZ, with each letter as a button/script. When the user clicks on "C" I want the script to sort the found set in alpha order and then make the active record the first record in the found set that begins with the letter "C". I should be able to write the script, but I can't figure out the calculation to move to a different record in the found set. Is anyone using a nav bar like this?

Works like a charm! Thanks!

Still not working. FM will accept the calculation, but when I enter info into the "completed by" field, nothing appears in the "date completed" field. Any other ideas?

I need to track stages of a project. For each step, I have a "completed by" field and a "completed on" field. When a person enters their initials in the "completed by" field I want the date to auto enter in the "completed on" field. I can't figure out the calculation. I searched the archives but didn't find an answer. Thanks in advance for your help!

THANKS! Now I get it! Problem solved. You are my heros!

Thanks to John and Ray for your replies. I still need help. The "previous balance" field is already <= 48. I need the "new balance" that the calculation field is calculating to be no greater than 48. I tried modifications of your suggestions to get this to work, but I can't get it right. Any other suggestions? I. E: previous balance = 48 days, + earned 15 days, - used 10 days, new balance is still 48 not 53.

I created a calculation field to track annual vacation and sick leave (previous yr balance + earned leave - used leave = new balance) and it is working just fine. However, for vacation time, we are only allowed to carryover a maximum of 48 days. What do I add to the calc to get a result no > 48?