thejkfarr

on the Iphone, when my clients enter data for fields 1,2, and 3. I would like for it to stop after the third and just show the fields with the data they entered, it instead loops back to field 1 and displays it's drop down menu. any way for it to just stop after field 3, showing no keyboard or drop down menu on the Iphone?

I hope this is an easy question. I have written a filemaker go app for the iPhone and my clients don't want the keyboard on the iPhone to pop up when an end user clicks a field. something like "only allow drop down list" but no keyboard. this possible?

Then that's the route i'll take. Thanks Comment!

Timelines typically has 20-140 records, EquipmentLines has 10-40, Notes has around 20.

1 to 10 possible pages of data Total, up to 5 pages for Table 2, 3 for Table 3, 1 for Table 4)

My clients have requested that I combine 3 reports into one. Table 1 (Parent) Jobs (Job ID, Customer) Table 2 (Child) TimeLines (fkJobID, Date, Employee, Start, End) Table 3 (Child) EquipmentLines (fkJobID, EQID, Date, Start, End) Table 4 (Child) NotesLines (fkJobID, NoteID, Date, Start, End) Currently I report on each Child table. My clients want the report to look like: JOBID (from Table1) Date, Employee, Start, End (from Table2) Date, EQID, Start, End (from Table3) Date, NoteID, Start, End (from Table4) Should I combine Table2-4 into one large table? (would be a major rewrite), loop script to copy related records to a reports table? Or is there a better way? What direction would you take?

Hoping for some help from you AWESOME people!!! I'm trying to validate time entries from a relationship, the problem: the time entries are entered into a portal and the records do not commit to trip the validation error. here is what I have: Job table (jobID, Customer, EmpID) time table (FKEmpID, date, timestart, timeend) layout based off of Job Table, portal to times. I'm looking for a better way to prevent overlapping time entries. Maybe i'm on the right track, I don't know.. still a newb. ATTACHED: a sample of the issue. More details inside the file timevalidation.zip

I have a simple time entry collection filemaker go solution that hooks up to my server Employee ID, Date, Time start, Time end I need to validate that the employee doesn't overlap times (enter 8-5 twice for the same date). I'm not quite sure how to go about it. Can anyone point me in the right direction? Thanks bunches!!!

I have a simple date search: global (startdate), global (enddate) and a Search script that throws that into a find on a list of records. works just fine, but the startdate and enddate global fields always retain their old values and never update. minor, but I don't want my clients to scroll months ahead to get to the current date. Maybe i'm doing the whole thing wrong, any advice? Update: I forgot to say, they do update for the search. Upon exiting filemaker and going back in, they default to old values.

that's awesome sauce right there!

Clent needs to split a record so they can easily import it into their payroll system. What I have in a record: (employee ID, time worked, bonus, Job) what they need in two seperate records, lines, or two rows in excel is: (employee ID, time worked, job) and (employee ID, bonus, job) What's a good practice to get this done? either to excel or CSV, or to a different table that can be exported.

I think that you have that calculation result formatted as a numerical value instead of text "Calculation result is a _____". Change it to text and see how that does.

that looks promising!!!! will try it out, thanks!

Beginner here! I have a simple time entry app that has suddenly gotten really complicated for me and I'm looking for some help. In my Lines table I have the following (Employee, Time worked, Date, Bill rate) I need to calculate overtime (1.5) based on hours worked over a week instead of daily. Can this be a running total based on 3 fields? Just wondering what the calculation might look like... just looking for some hints here. Thanks!

Is there a method of copying a list of records for a report? basicly here is my situation: My client sends out an invoice with a customized front (designed in form view) of the summaries of the charges. Following this, is the detail list (individual line item entries) They currently run these seperatly, print them out, compile them, rescan them, then send to client. I'm looking to cut all that out and generate the detail list right under the customized front first page. I know I could use a portal, but I read where it will not autogrow to the number of records only shrink with sliding (there could be more records than I allow for) I have 4 different tables that I need to provide details on, would be wonderful if I could get filemaker to pull in all 4 detailed lists and have them autogrow / shrink no matter the number of records. then my client just slaps a button :)

Your advice worked perfectly! It's actually much more complicated, there are 8 tables not just 2, I just over simplified it for posting reasons. Points to Doug!

I am developing a simple invoicing solution, and I need to provide a report that has a summary of information from 2 other tables. For the life of me, I can't seem to figure out how to apply the date range to the calculation. to simplify: table1 = labor sales, table2 = Item sales (assume each has a date field) I need to create a report that gives me summaries for a date range, a page that just has "total labor sales for date range" and "total item sales for date range". Can anyone give me some pointers on how to get the numbers to reflect the date ranges. Perhaps I don't understand how the relationship needs to be setup. Thanks kindly

well I think I have a workaround, at least so far in my testing. I had to put a script trigger for a commit on every field in my portal.

I've tried that as well, perhaps my order is wrong. my script is: delete portal row () Commit Records Refresh window (flush)

this is beautiful, thankyou thankyou thankyou

have a portal setup and sometimes, very rarely, but enough to be a headache, the line in the portal does not delete. When looking in the "lines" table, the record is in fact deleted, but it's still in the portal view. My clients can exit the database and when they log back in, it's gone. I'm using the simple "delete portal row" script step. i'm hoping other people have run into this same problem, and have a work around or perhaps i'm not doing something I should be.

You can also think about this as an invoiced line item, How would one add multiple line items with a click?

you bet: Employee table == > Employee Lines table My portal is setup off the Lines table pulling information from employee table. Employees are currently entered one at a time (one per row in lines) here is my portal {emp ID}{name}{date}{time} Currently it is setup where the end user selects empID and the rest auto-enters I'd like a script or some other method to add multiple empIDs at once, IE Team 25 would put in a column of 5 empIDs at once in Lines.

(Beginner)--Filemaker rocks! I have a simple time entry application, I have a portal where a manager enters employees time: emp ID 001 autoenters name and then they select time worked yada yada. I want to be able to select a team: IE manager selects team 25 and it autoenters all the employees into the portal and then they edit times if needed. I assume I make a button and set a script on it, but how do I make it enter multiple rows based on if an employee has been assigned to a team in the employee table? much thanks!

First Time Poster!!! We have a client who is looking for a solution to capture time entries from employees in the field. The employees are not in cell tower range, there will be roughly 50 of them. is there an offline filemaker go solution that would allow entries to be collected and synched up to the server when they entered into range? Sorry for the newbish question, but i'm a newb.