Alpha Video Training
Results 1 to 4 of 4

Thread: Only allow one choice in lookup grid for date/time

  1. #1
    Member
    Real Name
    Greg Taylor
    Join Date
    Feb 2009
    Location
    Columbus, Ohio
    Posts
    435

    Default Only allow one choice in lookup grid for date/time

    I have a lookup grid that is filtered by

    1. Date choice
    2. Time block (AM or PM)

    Once both are selected, the user clicks the lookup link and is presented with a list of choices that match the 2 field selections. What I want to do is only allow them to do this ONCE per date/time block. I want to avoid having a user having TWO of the same (ie. 10/12/12 AM). They should still be able to select a different date/time block.

    Any suggestions on how to accomplish this would be greatly appreciated! Thanks

  2. #2
    Member
    Real Name
    Greg Taylor
    Join Date
    Feb 2009
    Location
    Columbus, Ohio
    Posts
    435

    Default Re: Only allow one choice in lookup grid for date/time

    Bump on this.....still trying to figure it out. I am guessing I need to do something on the can insert record area....but not sure of how to accomplish it.

  3. #3
    "Certified" Alphaholic
    Real Name
    Larry Grupido
    Join Date
    May 2010
    Posts
    1,814

    Default Re: Only allow one choice in lookup grid for date/time

    Perhaps a couple pictures or a demo video? I am having trouble picturing the situation.

  4. #4
    "Certified" Alphaholic
    Real Name
    Gregg Schmidt
    Join Date
    Mar 2001
    Location
    Milwaukee
    Posts
    1,387

    Default Re: Only allow one choice in lookup grid for date/time

    Seems that after submit, you would check your table to see if the date choice/time block exists.
    If it does, cancel the entry (maybe even display a message that it's already been selected), if not,
    write the data.

Similar Threads

  1. JavaScript/Grid Date/Time Selector
    By Peter.Greulich in forum Code Archive
    Replies: 7
    Last Post: 11-01-2013, 04:28 PM
  2. Date/Time Format in Grid
    By lgrupido in forum Application Server Version 10 - Web/Browser Applications
    Replies: 1
    Last Post: 09-08-2011, 04:12 PM
  3. problem returning date from lookup grid
    By carlr in forum Application Server Version 10 - Web/Browser Applications
    Replies: 2
    Last Post: 03-22-2011, 10:05 AM
  4. populate an updated date/time field on submit in an update only grid
    By lemandras in forum Application Server Version 10 - Web/Browser Applications
    Replies: 0
    Last Post: 02-17-2011, 11:45 AM
  5. Mapping Each Lookup Choice to a Different Table
    By ronc8 in forum Application Server Version 10 - Web/Browser Applications
    Replies: 9
    Last Post: 08-09-2010, 03:10 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •