Hi FM people!
I have one problem which is probably simple to solve but so far solution eluded me.
I have a dropdown text field which offers a list of years (Table::Years). This is global field.
I have very simple find script:
Enter Find Mode [Pause: Off]
Set Field [Table::Order Date; Table::Years]
Constrain Found Set [ ]
Table::Order Date is a date field.
Idea is to perform find according to the value chosen from a dropdown list. However, this does not work. I'm getting "provided find criteria not valid".
But, if I enter manually one of the years from the list, It works. Same is valid if I write down a year in the script e.g. Set Field [Table::Order Date; 1980].
Set Field [Table::Order Date; Table::Years] itself works when in browse mode, but in find mode, nope
This is I guess a format issue, so I tried several combinations changing fields to text or date but without success.
Any help is appreciated
I’d like to show days since last race for a horse where the first race returns 0. I played around with ‘last’ and ‘GetNthRecord’ but something went wrong. I had some problems with races where the horse was scratched, but I can live with that.
Hi, I am using this calculation in portal which calculates days in portal Date - (GetNthRecord ( Date ; Get ( RecordNumber ) - 1 ) )
how can i modify or do something else to avoid (?) in the first row. Sample file attached for any modification/help.
Thanks for any help
So there's probably something simple, but do you guys know of a way to automate dates from one record to the next? Each record date needs to be seven days after the previous one, and I'd like for my client not to have to enter it manually. I tried doing
Let ( Today = ( ReleaseDate ) ;
Date ( Month ( Today ) ; Day ( Today ) + 7 ; Year ( Today ) )
and some others, but none appear to automatically fill in. Help!
My solution is build according to the 'separation model', so I would like to keep control of the local file containing the layout and presentation of the data hosted in the server.
I wonder if I could have a script to control wether the local file gets its structure, layout or scripting modified, so I need a function to control when a change to the file has been made before giving it a version number. When the file gets open only to work with the hosted data it's not a new version.