Search the Community
Showing results for tags 'numbers'.
Found 3 results
Suppose I have a column of numbers in a text field and I wish to export that field. What happens is that only the last number of the column gets exported. If, on the other hand, I separate each number by a comma, one after the other (not in a column), the export function works: all numbers are exported. The problem is that some other applications cannot easily read a comma-delimited text file--they prefer to read a column of numbers. So: is there any way to export a column of numbers (contained within one text field) to the disk?
NewBoard posted a topic in RelationshipsI am attempting to create an inspection sheet for our Quality Lab. Right now, all parts will be on revision 1. However, once this is up and running, these parts will receive revisions. What will ensue is a table with multiple identical part numbers, but different rev levels. What I want to happen, is that whenever an employee makes a new inspection sheet, FileMaker will only request the data from the newest rev. My proposed solution is to have another field that will be 0 if it's not the newest, and 1 if it is the newest. Then the inspection sheet will only request data from records that have a 1. I have not yet figured out how to do this though. If someone else has a better solution though, I am all ears!
I have a number field that I would like to auto enter either (2, 3, or 9) at random every time a new record is created. Please help! Thanks Matt I tried to do a sequenced auto enter but filemaker simply counts up from 1 and I can't specify the 3 numbers. Thanks