Can I change the entry form to just take year of birth?

Welcome User Forums Knowledgebase Can I change the entry form to just take year of birth?

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #88
    Chris
    Keymaster

    I want to use the entry forms, but I only want to know the year of birth. How can I get TScore to accept the revised format?
    First, unprotect the entry form (password ‘barani’).
    Next change the format of the DoB cells to be Numeric, with 0 decimal places.
    Next change the Validation rules on these cells to be a range check (say, 1050 to 2010).
    Now edit the formula for the Age cells, by removing the occurrences of “YEAR(“ and the matching “)”.
    For example:
    =IF(INDIRECT(“E”&ROW())=””,””,IF(INDIRECT(“G”&ROW())=””,INDIRECT(“Lists!L”&($I$3-YEAR(INDIRECT(“E”&ROW())))),HLOOKUP(INDIRECT(“G”&ROW()),GradeAges,($I$3-YEAR(INDIRECT(“E”&ROW()))),FALSE)))
    Becomes:
    =IF(INDIRECT(“E”&ROW())=””,””,IF(INDIRECT(“G”&ROW())=””,INDIRECT(“Lists!L”&($I$3- INDIRECT(“E”&ROW()))),HLOOKUP(INDIRECT(“G”&ROW()),GradeAges,($I$3-INDIRECT(“E”&ROW())),FALSE)))
    (You can do this for the first row, then copy it into all the others).

Viewing 1 post (of 1 total)
  • You must be logged in to reply to this topic.