shango

I have 2 tables. One to many relationship. I would like to get a count of the children that relate to the parent. I can't seem to get this to filter right. I keep getting a count of all the children or nothing at all, no matter what I do. If an example is needed I can whip one up. Thanks for any help.

Lol! Thanks, I didn't realize that was automatic.

Thank you for the pointer. That worked like a charm. The theory part seems so obvious and I should be thinking that way. But I'm learning. This is what worked for me in the job status calc field. I don't know if this is the most efficient way, but it worked. if (Count ( tasks::kf_jobs ) = Count ( tasks::task_status ); int ( 1 ) )

I have a one to many relationship where I need to calculate the value of a field in the parent based upon the value of a field in the children. It's basically just a true of false value. The parent is set to true by default. If all the children have a false value, then the parent is false. My apologies if the explanation is poor. I've attached a sample which makes things clear. I appreciate any pointers. conditions.fp7.zip

Well that was it. Never would have thought to look that one up. Thank you very much. It might be worth at least familiarizing myself with all the built in functions.

Hi and thanks for responding so quickly! Here's what I've come up with so far. Round((shots::frames)/30;2) However I need to round up to the nearest .5 (half second) For example: 29 frames rounds up to 1 second 31 frames rounds up to 1.5 seconds 46 frames rounds up to 2 seconds I'm stumped.

I have a field where users input "frames" as a whole number and I need to have "seconds" calculated automatically. 30 frames = 1 second The resulting seconds would auto populate another field. Not sure how to proceed here. Any guidance is appreciated. Thanks

Thanks. I just went with an extra field for now.

Thank you, that worked perfectly.

Yes, that is the order I'm after These are shot numbers from a tv shooting schedule. They look like this when sorted correctly. 008 008a 009 009a 009b 010 010a 010b I'm starting to feel that my problem is not with the leading zeros calc, but rather with the sorting. Perhaps I need to make a seperate field for the letter increments. Is there a way around this? Again, I appreciate your help.

Thanks for the reply. That works nicely. However, when I input a 3 digit numbers the sort order gets screwy. 001a 0051 0101 051a Any suggestions?

sorry for being criptic. I have a field where users will input values that look like this: 1a 1b 1c 2a 2b 2c I need to add leading zeros automatically. so, I used a calulation that I found which inserts leading zeros just fine for a numbers only field. Right ("00" & Int ( shots::shot); 3) How can I add leading zeros in the case of a mixed character field? Here's what I need: 001a 001b etc. Thanks

I'd like to have a field that displays the file name of a container image programmatically. How can I get the file name and insert it into a given field? The images are currently being imported into the file. Later I'll setup an external data file just for the images. I appreciate any pointers.

I have a calculation that looks like this: Right ("00" & Int ( shots::shot); 3) This works fine for num fields. However, I would like to use num and characters. "001a" for example. Can't seem to figure this one out.

Thank you for the great tip. The video is for subscribers only. However, in the Extras folder, the "to do list" example has a nice implementation of what I need.