AnsweredAssumed Answered

Multiple fields error "is defind to require a value....."

Question asked by TreyWomack on Jan 6, 2012
Latest reply on Jan 6, 2012 by TreyWomack

Title

Multiple fields error "is defind to require a value....."

Post

First off, let me say that I'm not that well versed in Filemaker. I inherited this program which was patched together to do our payroll. I have changed nothing when this error just started appearing.

I'm using Filemaker Pro 10 Advanced.

This is my error:

"BillDay" is defind to require a value, but is not available on this layout. Use another layout to assign a value to this field.

I know enough to clear the validation field, which always rechecks itself after I save and close. Since this is a field that is never used anyway, I went ahead and just deleted it to see if that would fix my problem. Well, it fixed that problem but then another field popped up with the same error. If I delete that field, then another field will pop up with the same error. I don't want to start deleting all kinds of fields, when I'm not very familiar with how this was put together.


I've pasted the script in hopes that someone can take a look at it and tell me if you see anything that might be causing my problem.  Thanks fro your help!

  • Show Custom Dialog [ Title: "Alert"; Message: "This will write all records to the solomon database and archive them permanently. Are you sure you want to do this?"; Buttons: “OK”, “Cancel” ]
  • If [ Get ( LastMessageChoice ) = 2 ]
  • Exit Script [ ]
  • End If
  • Refresh Window [ Flush cached join results; Flush cached SQL data ]
  • Perform Script [ “Print Notes to Change” ]
  • Go to Layout [ “Submit to Solomon” (Remote) ]
  • Perform Find [ Specified Find Requests: Find Records; Criteria: Timesheet::Work Code: “*” ] [ Restore ]
  • Set Variable [ $$FoundCountworked; Value:Get ( FoundCount ) ]
  • Perform Find [ Specified Find Requests: Find Records; Criteria: Remote::Submit: “submit” ] [ Restore ]
  • Constrain Found Set [ Specified Find Requests: Omit Records; Criteria: Remote::updated to solomon: “UPDATED” ] [ Restore ]
  • Set Variable [ $$FoundCountSubmitted; Value:Get ( FoundCount ) ]
  • // If [ $$FoundCountSubmitted ≠ $$FoundCountworked ]
  • // Show Custom Dialog [ Title: "Alert"; Message: "You must have all tickets ready to submit before proceeding."; Buttons: “OK” ]
  • // Exit Script [ ]
  • // End If
  • Sort Records [ Specified Sort Order: Timesheet::Start Time; ascending ] [ Restore; No dialog ]
  • Go to Record/Request/Page [ First ]
  • Loop
  • If [ Remote::Ticket Number ≠ "TAY0000000" ]
  • Perform Script [ “Write Inventory” ]
  • Perform Script [ “Write return Inventory” ]
  • Set Error Capture [ On ]
  • If [ Remote::Call TypeStrip ≠ dbo.smServCall::CallType ]
  • Copy [ Remote::Call TypeStrip ] [ Select ]
  • Paste [ dbo.smServCall::CallType ] [ Select ]
  • End If
  • If [ Remote::Date Promised to Solomon ≠ "" ]
  • Copy [ Remote::Date Promised to Solomon Calc ] [ Select ]
  • Paste [ dbo.smServCall::ServiceCallDateProm ] [ Select ]
  • End If
  • If [ Remote::Call Status to Solomon ≠ dbo.smServCall::CallStatus ]
  • Copy [ Remote::Call Status to Solomon ] [ Select ]
  • Paste [ dbo.smServCall::CallStatus ] [ Select ]
  • End If
  • If [ Remote::Assigned Tech to Solomon ≠ dbo.smServCall::AssignEmpID ]
  • Copy [ Remote::Assigned Tech to Solomon ] [ Select ]
  • Paste [ dbo.smServCall::AssignEmpID ] [ Select ]
  • End If
  • Copy [ Remote::Notes to Solomon ] [ Select ]
  • Paste [ dbo.Snote::sNoteText ] [ Select ]
  • Set Field [ Remote::updated to solomon; "UPDATED" ]
  • Pause/Resume Script [ Duration (seconds): 5 ]
  • End If
  • Go to Record/Request/Page [ Next; Exit after last ]
  • If [ Get ( LastError ) ≠ 0 ]
  • // Halt Script
  • End If
  • Set Error Capture [ Off ]
  • End Loop
  • Go to Layout [ “Check Notes” (Remote) ]
  • Perform Script [ “Export All” ]
  • Perform Script [ “Import All” ]
  • Perform Script [ “Show Updated Info Dean” ]
  • Perform Script [ “Show Updated Info Steve” ]
  • Perform Script [ “Show Updated Info” ]
  • Perform Script [ “Inventory Report” ]
  • Enter Browse Mode
  • // Perform Script [ “Clear All Data” ]
  • Go to Layout [ “Startup” (Timesheet) ]

Outcomes