I need a unique setting done how do I do it?

  • Profile Image
    partyrockersvip
    Asked on May 29, 2012 at 05:06 PM
    My form with you guys determines what city is pick in drop down box. Once you pick the city the next box below are the nightclubs and pool parties and another field called adult clubs for that city alone. I need it to work just like that. All I have info for now is Las Vegas as you can see. Once the form is submitted I would like the spreadsheet to separate each nightclubs/pool parties or adult clubs by date each day. The url is up but the site isn't I might just do a one pager with a graphic just so I can test the form.
  • Profile Image
    jonathan
    Answered on May 29, 2012 at 08:48 PM

    Hi,

    You will have to setup condition logic on the form (use this guide -Conditional-Logic-on-Forms)

    I clone your form and started the initial sample for Las Vegas and Phoenix.
    Here is the form:  

    http://www.jotform.me/form/21497531337456

    Please try test it. You can also clone (-How-to-clone-an-existing-form-from-a-URL) to see the conditions.

    If the form submission report is downloaded to Excel or integrated to spreadsheet or generated to an Excel report, you can easily setup an "autofilter" in Excel or spreadsheet as this is a part of the functionalities. Meaning, you can easily separate each field/filter to what you require once you have them on the Excel/spreadsheets already.

    Please inform us if you need further assistance on it. Thanks.

     

  • Profile Image
    partyrockersvip
    Answered on May 30, 2012 at 03:53 PM
    Hello Jonathan
    Is it anyway for me to copy the code from the form you did and use that.
    Could program the code under my account like you did on the link also for
    other two cities as well. Im new to all this so I'm trying to figure it
    out. The jotform website is great Im just pressed for time a this point.
    Thank you
  • Profile Image
    jeanettebmz
    Answered on May 30, 2012 at 08:02 PM

    Yes, you can use my colleague's  form, this is the  URL of it  http://www.jotform.me/form/21497531337456j

    Please, follow the instructions on the link he provided to you: How-to-clone-an-existing-form-from-a-URL - just copy the form's URL and paste it, following the guide above

    Should you need further assitance, let us know

    Jeanette



  • Profile Image
    partyrockersvip
    Answered on May 30, 2012 at 08:06 PM
    Can u also add Miami and Los Angeles I see you have Phoenix and Las Vegas could you add those as well too your colleague's  form
    Sent via BlackBerry from T-Mobile
  • Profile Image
    jeanettebmz
    Answered on May 30, 2012 at 10:50 PM

    If you are talking about adding these places to the Party cities dropdown menu, it is already updated

    Regards

    Jeanette

  • Profile Image
    partyrockersvip
    Answered on May 31, 2012 at 03:22 PM
    Jeanette
    I didn't get updated link so I can clone form I need Miami and Los Angeles
    added please I see where he added Phoenix and Las Vegas so the form will
    change but he didn't add those two cities to the form can you add these two
    cities to where they function as well? Thank you for you time and help
    Jarrett Neal
    J-Neal Enterprises, LLC
  • Profile Image
    jeanettebmz
    Answered on May 31, 2012 at 03:59 PM

    The link is the same one http://www.jotform.me/form/21497531337456

    Let me know if you still need assistance

    Jeanette

  • Profile Image
    jeanettebmz
    Answered on May 31, 2012 at 04:03 PM

    I think you would need me to add more conditionals to it, but I don't see any field related to Los Angeles or Miami, currently when the user selects Miami or los Angeles , it will hide the other fields (related to Las vegas or Phoenix) because there is nothing on that form

  • Profile Image
    partyrockersvip
    Answered on May 31, 2012 at 04:07 PM
    I know its same link but only two working right is Las Vegas and Phoenix the other two Los Angeles and Miami aren't function. When you select city the clubs change in the nightclub field those two cities aren't working he put some generic clubs for phoenix because I don't have nightclubs could he also do this for Los Angeles and Miami please?
    Sent via BlackBerry from T-Mobile
  • Profile Image
    partyrockersvip
    Answered on May 31, 2012 at 04:08 PM
    Just add some generic name like Los angeles club 1 club 2 do the same for Miami and I will be set
    Sent via BlackBerry from T-Mobile
  • Profile Image
    jeanettebmz
    Answered on May 31, 2012 at 04:49 PM

    Ok, here you have MY clone , which is a clone of my colleagues

    Hopefully this is what you are looking for

    Cheers!

    Jeanette

  • Profile Image
    partyrockersvip
    Answered on June 02, 2012 at 03:41 PM
    Some one erased the clone you made for me ? WHY? I need to copy code to put
  • Profile Image
    partyrockersvip
    Answered on June 02, 2012 at 05:40 PM
    can you send me the clone source code for the one you did please I click
    you link within this email and it came up empty it said this form was
    deleted by the owner? the MY clone you did for me with the last minute
    changes.
  • Profile Image
    partyrockersvip
    Answered on June 02, 2012 at 07:03 PM
    Also can you delete off my account all the other forms beside the latest
  • Profile Image
    partyrockersvip
    Answered on June 02, 2012 at 07:17 PM
    Jeanette
    I need you to delete all other forms under my account except for the one
    that you did called My Form you made the last changes to it. Also I need
    the form to go back to my website once form is submitted. How can you code
    to go back to a clean form because now all it does when I hit submit is go
    to submit page for jotform and never goes back to my site or to a clean
    form to where customer can submit another form. Is this possible? Also
    could you check intergation I made for the form to go to google document
    excel spreadsheet I don't see nothing when i log into my documents in
    google for Nightclubs under "partyrockersvip@gmail.com. Test my website at:
    www.partyrockersvip.com
    content="true" />
    Form
    type="text/css" target="_blank" href="http://jotform.co/css/styles/nova.css?3.0.3616" rel="nofollow noopener"
    />




    method="post" name="form_21516705971859" action="
    http://submit.jotform.co/submit/21516705971859/">value="21516705971859" type="hidden" />




    Guest List for Nightclubs / Pool
    Parties / Adult Clubs


    class="form-label-left" for="input_16"> Date & Time
    class="form-sub-label-container">name="q16_date[month]" maxlength="2" value="05" size="2" type="text"
    /> / class="form-sub-label" for="month_16"> Month class="form-sub-label-container">name="q16_date[day]" maxlength="2" value="31" size="2" type="text" />class="date-separate"> / class="form-sub-label" for="day_16"> Day class="form-sub-label-container">name="q16_date[year]" maxlength="4" value="2012" size="4" type="text" />
    Year
    id="input_16_pick" alt="Pick a Date" align="absmiddle" src="
    http://jotform.co/images/calendar.png" /> for="input_16_pick">    


    class="form-label-left" for="input_15"> Party Citiesclass="form-required">*
    id="input_15" class="form-dropdown validate[required]"
    name="q15_partyCities"> Las
    Vegas Phoenix (Coming
    Soon) Miami (Coming Soon)
    Los Angeles (Coming
    Soon)


    for="input_4"> LV Nightclubs / Pool Parties
    id="input_4" class="form-dropdown" name="q4_lvNightclubs">
    Moon
    Ghostbar Marquee value="Chateau"> Chateau Gallery
    Vanity
    Playboy Rain value="1Oak"> 1Oak Haze value="LAX"> LAX Mix Lounge
    Surrender Tryst
    Hyde TAO
    Lavo
    The Bank Revolution value="Tabu"> Tabu Foundation
    Room Crown Nightclub
    Artisan Drais
    Pure Vanguard Lounge Gold Lounge
    VooDoo Cherry NightClub DitchFridays Pool / Palms Casino value="Wet Republic Pool / MGM Casino"> Wet Republic Pool / MGM Casino
    Encore
    BeachClub Pool / Wynn Casino Bare Pool / Mirage Casino Liquid Pool / Aria Casino Rehab Pool / HardRock Casino value="TAO Beach Pool / Venetian Casino"> TAO Beach Pool / Venetian Casino


    class="form-label-left" for="input_17"> Phoenix Nightclubs / Pool Parties

    id="input_17" class="form-dropdown" name="q17_phoenixNightclubs">
    Phoenix NC 1 value="Phoenix NC 2"> Phoenix NC 2


    for="input_6"> LV Adult Clubs
    id="input_6" class="form-dropdown" name="q6_lvAdult">
    Sapphires Spearment Rhino CrazyHorse
    3 Larry Flynt Hustlers
    Treasures value="Vince Neil's Girls Girls Girls"> Vince Neil's Girls Girls Girls
    Cover Girls value="Palomino"> Palomino LollyPop's
    Little Darlings
    Déjà vu
    Showgirls Discreet value="Club Paradise"> Club Paradise Cheetah's Topless Lounge value="Privilege"> Privilege


    class="form-label-left" for="input_18"> Phoenix Adult Clubs
    id="input_18" class="form-dropdown" name="q18_phoenixAdult">
    Phoenix AC 1 value="Phoenix AC 2"> Phoenix AC 2


    class="form-label-left" for="input_21"> L.A Clubs
    id="input_21" class="form-dropdown" name="q21_laClubs">
    Club 1 Club 2


    class="form-label-left" for="input_22"> Miami Clubs
    id="input_22" class="form-dropdown" name="q22_miamiClubs">
    club 1
    club 2


    class="form-label-left" for="input_19"> Nightclubs / Pool Parties
    id="input_19" class="form-dropdown" name="q19_nightclubs19">
    Moon
    Ghostbar Marquee value="Chateau"> Chateau Gallery
    Vanity
    Playboy Rain value="1Oak"> 1Oak Haze value="LAX"> LAX Mix Lounge
    Surrender Tryst
    Hyde TAO
    Lavo
    The Bank Revolution value="Tabu"> Tabu Foundation
    Room Crown Nightclub
    Artisan Drais
    Pure Vanguard Lounge Gold Lounge
    VooDoo Cherry NightClub DitchFridays Pool / Palms Casino value="Wet Republic Pool / MGM Casino"> Wet Republic Pool / MGM Casino
    Encore
    BeachClub Pool / Wynn Casino Bare Pool / Mirage Casino Liquid Pool / Aria Casino Rehab Pool / HardRock Casino value="TAO Beach Pool / Venetian Casino"> TAO Beach Pool / Venetian Casino


    class="form-label-left" for="input_20"> Adult Clubs
    id="input_20" class="form-dropdown" name="q20_adultClubs20">
    Sapphires value="Spearment Rhino"> Spearment Rhino value="CrazyHorse 3"> CrazyHorse 3 Larry Flynt Hustlers
    Treasures Vince
    Neil's Girls Girls Girls Cover Girls
    Palomino value="LollyPop's"> LollyPop's
    Little Darlings
    Déjà vu Showgirls
    Discreet Club Paradise
    Cheetah's Topless Lounge
    Privilege


    for="input_7"> Bottle & Table Service
    class="form-sub-label-container">class="form-dropdown" name="q7_bottle"> value="Vodka"> Vodka Tequila
    Gin Rum
    Whiskey Cognac
    Brut Rose'
    Magnums class="form-sub-label" for="input_7"> $500 an up for bottle service 28% Tax
    and Gratuity


    class="form-label-left" for="input_10"> First & Last Name
    class="form-textbox" name="q10_first" size="20" type="text" />


    class="form-label-left" for="input_11"> Email Address
    class="form-textbox" name="q11_emailAddress" size="20" type="text" />


    class="form-label-left" for="input_12"> Phone Number
    class="form-textbox" name="q12_phoneNumber" size="20" type="text" />


    class="form-label-left" for="input_13"> Number Of People In Your Group

    class="form-sub-label-container">name="q13_numberOf13" size="20" type="text" /> class="form-sub-label" for="input_13"> Type Number Of People In Your Group.




    id="input_2" class="form-submit-button" type="submit"> Submit



    Should be Empty: type="text" />


    type="hidden" />


  • Profile Image
    partyrockersvip
    Answered on June 02, 2012 at 08:14 PM
    Nevermind last email sent I figured it out thank you. But here is my
    problem maybe you could help me with this. The form works for the most part
    but how do I separate each nightclub into a spreadsheet so it does all be
  • Profile Image
    jeanettebmz
    Answered on June 02, 2012 at 08:44 PM

    Hello again

    I apologize for coming late back to you, I took a day off.

    I am please you could figure out most of the issues, regarding to get a separte spreeadsheet automatically  for each nightclub , that is not possible . A workaround would be seting a filter into excel for each night club

    Let me know if you need further assistance

    Jeanette

  • Profile Image
    partyrockersvip
    Answered on June 02, 2012 at 08:53 PM
    So how do I do that in excel to print out each nightclub guest list? Is that a condition or a spread sheet function I could use to do so? Or a programming array? Also how can I get the program once they submit form to go back to form on my website and it be clear as form as well? Because once I hit submit button it take me too submit.jotform.us page and stays there?
    Sent via BlackBerry from T-Mobile
  • Profile Image
    jeanettebmz
    Answered on June 02, 2012 at 09:04 PM

    Could you please clone my form again, it is already available, I am sorry that I deleted it by mistake

    Regarding to the Excel part, here I leave you a guide on how to filter in Excel

     

    Regards

    Jeanette

  • Profile Image
    partyrockersvip
    Answered on June 02, 2012 at 11:19 PM
    Hey Jeanette I apreciate everything. Hey you left off Miami AdultClubs
    Field. I figure out how to get the submission to go back to website after
    submitted the form as well. Learn a little by little.
  • Profile Image
    jeanettebmz
    Answered on June 02, 2012 at 11:22 PM

    You are very welcome! It is good to know you figured it out.

    Should you need further assistance, let us know . We are always glad to assist

    Jeanette

  • Profile Image
    partyrockersvip
    Answered on August 12, 2012 at 02:13 AM
    I need help getting my functions to work for *Miami and Los Ang*eles within
    the Party Cities box, So when you click on the Miami or Los Angeles the
    Adult Club boxes don't pop up like it does for Las Vegas and Phoenix only
    the Miami and Los Angeles Nightclubs pop up. Could you fix this for me?
    Username: PartyRockersVip
    Form to correct is: Clone of Clone of Guest List for Nightclubs
  • Profile Image
    jonathan
    Answered on August 12, 2012 at 08:04 AM

    Hi,

    I did tested your form http://www.jotform.us/form/21523669426154 and it seems that dropdown for Miami and Los Angeles is working already. Can you please provide us more details as to what is you needed done on the form?

    Will await your update.

    Thanks.

  • Profile Image
    partyrockersvip
    Answered on August 15, 2012 at 06:26 PM
    When you select city and state, you are right the drop down boxes for Miami
    and Los Angeles Nightclub comes up on the form but not the Adult Club drop
    down boxes. Thats all sorry for confusion.
  • Profile Image
    Mike_T
    Answered on August 15, 2012 at 07:24 PM

    I have cloned your form and added the following condition:

    http://form.jotformeu.com/form/22277027545353

    Do you want to change/add something else?

  • Profile Image
    partyrockersvip
    Answered on August 19, 2012 at 07:29 PM
    Yeah when you click Miami for cities the Los Angeles Adult Club pops up as
    well. Everything else is fine!
  • Profile Image
    jeanettebmz
    Answered on August 19, 2012 at 07:32 PM

    Great to hear that!

    Cheers!

  • Profile Image
    partyrockersvip
    Answered on August 19, 2012 at 07:35 PM
    I you guys to fix that one little thing when you click Miami for cites the
    Los Angeles Adult box pops up as well but other that than everything looks
    good
  • Profile Image
    NeilVicente
    Answered on August 20, 2012 at 06:51 AM

    @partyrockersvip

    Fixed. Can you please check?

    http://www.jotform.us/form/21523669426154

  • Profile Image
    partyrockersvip
    Answered on August 28, 2012 at 01:54 PM
    Thank you for all the help you guys are VERY AWESOME!!!! but I have a few
    more request to test you computer programming skills. This one is not so
    difficult go to my site where i put your form up at: www.MrVegasVip.net see
    how the form is all bunch up on the site out of order. I need the spacing
    in code so its doesn't look like that when I copy the source code to the
    HTML box on my website web builder. Here is the source code below i use:
    _____________________________________________________________________________________________________________
    type="text/javascript">

    type="text/css" />


    name="form_21523669426154" id="21523669426154" accept-charset="utf-8">






    Guest List for Nightclubs / Pool Parties / Adult Clubs


    Try to guest list before 8:00 pm in any time zone.





    Date & Time*

    class="form-sub-label-container">size="2" maxlength="2" value="08" />class="date-separate"> /
    id="sublabel_month"> Month class="form-sub-label-container">maxlength="2" value="28" /> /

    Day class="form-textbox validate[required]" id="year_16"
    name="q16_date16[year]" type="text" size="4" maxlength="4" value="2012" />

    Year
    Pick a<br/>Datealign="absmiddle" />

       





    Party Cities*


    style="width:150px" id="input_15" name="q15_partyCities">

    Las Vegas
    Phoenix (Coming Soon)

    Miami (Coming Soon)

    Los Angeles (Coming
    Soon)




    Las
    Vegas Nightclubs / Pool Parties

    name="q4_lasVegas">

    Moon
    Ghostbar
    Marquee
    Chateau
    Gallery
    Vanity
    XS
    Rain
    1Oak
    Haze
    LAX
    Mix Lounge
    Surrender
    Tryst
    Hyde
    TAO
    Lavo
    The Bank
    Revolution
    Tabu
    Foundation Room
    Crown Nightclub
    Artisan
    Drais
    Pure
    Vanguard Lounge
    Gold Lounge
    VooDoo
    Cherry
    NightClub (Red Rock Casino)
    DitchFridays
    Pool / Palms Casino
    Wet Republic
    Pool / MGM Casino
    Encore
    BeachClub Pool / Wynn Casino
    Bare Pool / Mirage
    Casino
    Liquid Pool / Aria
    Casino
    Rehab Pool /
    HardRock Casino
    TAO Beach
    Pool / Venetian Casino





    Phoenix Nightclubs / Pool Parties

    name="q17_phoenixNightclubs">

    Phoenix NC 1
    Phoenix NC 2




    Los
    Angeles Nightclubs / Pool Parties

    name="q21_losAngeles21">

    Club 1
    Club 2




    Miami
    Nightclubs / Pool Parties

    name="q22_miamiNightclubs22">

    club 1
    club 2




    Las
    Vegas Adult Clubs

    name="q6_lasVegas6">

    Sapphires
    Spearment Rhino
    CrazyHorse 3
    Larry Flynt Hustlers

    Treasures
    Vince Neil's
    Girls Girls Girls
    Cover Girls
    Palomino
    LollyPop's
    Little Darlings
    Dvu Showgirls
    Discreet
    Club Paradise
    Cheetah's Topless
    Lounge
    Privilege





    Phoenix Adult Clubs

    name="q18_phoenixAdult18">

    Phoenix AC 1
    Phoenix AC 2




    Los
    Angeles Adult Clubs

    name="q27_losAngeles">

    Option 1
    Option 2
    Option 3




    Miami
    Adult Clubs

    name="q26_miamiAdult26">

    Option 1
    Option 2
    Option 3





    Nightclubs / Pool Parties

    name="q19_nightclubs19">

    Moon
    Ghostbar
    Marquee
    Chateau
    Gallery
    Vanity
    Playboy
    Rain
    1Oak
    Haze
    LAX
    Mix Lounge
    Surrender
    Tryst
    Hyde
    TAO
    Lavo
    The Bank
    Revolution
    Tabu
    Foundation Room
    Crown Nightclub
    Artisan
    Drais
    Pure
    Vanguard Lounge
    Gold Lounge
    VooDoo
    Cherry NightClub
    DitchFridays
    Pool / Palms Casino
    Wet Republic
    Pool / MGM Casino
    Encore
    BeachClub Pool / Wynn Casino
    Bare Pool / Mirage
    Casino
    Liquid Pool / Aria
    Casino
    Rehab Pool /
    HardRock Casino
    TAO Beach
    Pool / Venetian Casino




    Adult
    Clubs

    name="q20_adultClubs20">

    Sapphires
    Spearment Rhino
    CrazyHorse 3
    Larry Flynt Hustlers

    Treasures
    Vince Neil's
    Girls Girls Girls
    Cover Girls
    Palomino
    LollyPop's
    Little Darlings
    Dvu Showgirls
    Discreet
    Club Paradise
    Cheetah's Topless
    Lounge
    Privilege




    Bottle &
    Table Service
    class="form-sub-label-container">style="width:150px" id="input_7" name="q7_bottle">

    Vodka
    Tequila
    Gin
    Rum
    Whiskey
    Cognac
    Brut
    Rose'
    Magnums

    $500 an up for
    bottle service 28% Tax and Gratuity




    First & Last Name*


    id="input_10" name="q10_first" size="20" />




    Email Address*


    id="input_11" name="q11_emailAddress" size="20" />




    Phone Number*


    id="input_12" name="q12_phoneNumber" size="20" />




    Number Of Girls*

    class="form-sub-label-container">
    Type Number Of
    People In Your Group.



    Number
    of Guys

    name="q29_numberOf29" size="20" />






    Submit





    Should be Empty:




    value="21523669426154" />


    _____________________________________________________________________________________________________________
    *Second* I want a condition at around 8:00 pm all *nightclubs* guest are
    closed text my number 310.279.7391 for further questions. Also after form
    is submitted it takes you to THANK U PAGE FOR SUBMITTING once submitted can
    it be redirect back to form if customer wants to put in another entry
    instead of staying on the THANK U PAGE FOR SUBMITTING.
    *Third *is there any way to get each nightclub entry separated for that
    particular night on that particular day as one guestlist for that
    particular club. *So for example* all entries for Moon Nightclub on
    Aug 27,2012 will be on one excel spreadsheet or word document for that
    particular night for entry into nightclub. Guest list cut off time at
    8:00pm and reopens for next day at 12:00AM. I know how it is setup now
    all entries go to my email but its one by one in separate email.
    Things would be so much easier if I had each club guest list separated for
    that day and email to my email address for each nightclub in spreadsheet or
    word document form.
  • Profile Image
    fxr
    Answered on August 28, 2012 at 05:53 PM

    Is there any particular reason why you are embedding the forms full source?

    Perhaps you could try using the iframe embed code on your webpage?

  • Profile Image
    partyrockersvip
    Answered on August 29, 2012 at 03:11 AM
    Ok cool also I had these things I wanted to know as well.
    *Second* I want a condition at around 8:00 pm all *nightclubs* guest are
    closed text my number 310.279.7391 for further questions. Also after form
    is submitted it takes you to THANK U PAGE FOR SUBMITTING once submitted can
    it be redirect back to form if customer wants to put in another entry
    instead of staying on the THANK U PAGE FOR SUBMITTING.
    *Third *is there any way to get each nightclub entry separated for that
    particular night on that particular day as one guestlist for that
    particular club. *So for example* all entries for Moon Nightclub on
    Aug 27,2012 will be on one excel spreadsheet or word document for that
    particular night for entry into nightclub. Guest list cut off time at
    8:00pm and reopens for next day at 12:00AM. I know how it is setup now
    all entries go to my email but its one by one in separate email.
    Things would be so much easier if I had each club guest list separated for
    that day and email to my email address for each nightclub in spreadsheet or
    word document form.
  • Profile Image
    EduardoMendez
    Answered on August 29, 2012 at 10:17 AM

    Hi partyrockersvip ,

    I would be glad to look for solutions to your issue.  Can you please let me know which form on your acct is the one that you are wanting to change?  I see a "clone of a clone of guest list for night clubs" and "Clone 2".

    Thanks!

  • Profile Image
    partyrockersvip
    Answered on August 30, 2012 at 04:52 AM
    Clone of Clone of guest for night clubs is the one
  • Profile Image
    EduardoMendez
    Answered on August 30, 2012 at 02:32 PM

    Hi, I am looking into your question, however, I haven't been able to create a time trigger to dissable your form and promt the user to text you.  There is a condition feature that works with dates, but I haven't been able to make it work for a specific time.  I will update you as soon as I find an answer for that issue,  

    As per the submissions, You can integrate your form with Google docs or have a HTML report that produces a spreadsheet that appends each entry.   Once on a spreadsheet you can create your own reports.

     

    Or if you would like separate reports you can create a different form for each city and embed each form inside a master form.  

    To do this, you can use the Free HTML fields.  :  Follow these directions:

    Create a master form with no submition button and one drop down field with the names of options for "City". Add 4 (or as many cities as you will be adding) HTM fields.

    Create a form for each city with all the information that you need and obtain the iFrame code.  

    Paste the corresponding iFrame code to each of the Free HTML fields on the master form.

    Use the conditions to show/hide HTML fields according the the dropdown menu that selects the city.

    You will not see the name of the HTML fields, but you will be able to select them when setting the conditions

    Here is an example of that idea. Inside there are four diferent forms embeded.  You can edit and produce separate reports for each city.  

    Hope this information helps!

  • Profile Image
    partyrockersvip
    Answered on August 30, 2012 at 03:05 PM
    Ok cool let me know if you can create a time trigger to disable the form.
    As for the other part you mention to be honest I'm lost I just want it to
    seperate all the clubs guest list for that particular day. So if i get 50
    entries on 8/31/2012 for Moon or Vanity Nightclub they will all be on
    spreadsheet or word document separated. Is it anything you can do to help?
    Sorry for inconvenience
  • Profile Image
    jeanettebmz
    Answered on August 30, 2012 at 08:49 PM

    @partyrockersvip

    There is no way to disable a form that is hosted into our servers, unless you do it manually.

    You can separate all the club guest list and filter them by date into an Excel environment. All you have to do is to download the Excel file and apply the filter

    Please find help on these external links

    http://office.microsoft.com/en-us/excel-help/filter-data-in-a-range-or-table-HP010073941.aspx

    http://office.microsoft.com/en-us/excel-help/filter-by-using-advanced-criteria-HP005200178.aspx

  • Profile Image
    partyrockersvip
    Answered on September 03, 2012 at 04:47 PM
    Is it a way if the customer trys to guestlist at cut off time of 8:30PM or
    9:00PM a popup text can occur on the form? Also I just notice I have a
    problem, I need guest to be able to select more than one club if they would
    like to check out in one night on the form so they don't have to repeat do
    it 2 to 3 times to guest list for different clubs. Is it something you
    guys can help me with?
    Now far as excel filters can I apply where I don't have to do them manually
    each day? I just need each club to have a unique ID so when clients select
    the club of preference Moon Nightclub will have its own excel spreadsheet
    list for that particular day as well Ghostbar, Marquee etc etc. This
    condition have to be program too know when the guest list time cuts off and
    reopens for next day.
  • Profile Image
    jonathan
    Answered on September 03, 2012 at 06:41 PM

    @partyrockersvip

    Is it a way if the customer trys to guestlist at cut off time of 8:30PM or 9:00PM a popup text can occur on the form? 

    You can use the 'hover' text property of the field for this. And for the dropdown you can also set its size property, to display more than 1 selection

    Here is a clone of your form http://www.jotform.me/form/22467376446462 with those feature applied.

    Now far as excel filters can I apply where I don't have to do them manually each day? I just need each club to have a unique ID so when clients select the club of preference Moon Nightclub will have its own excel spreadsheet list for that particular day as well Ghostbar, Marquee etc etc. 

    In Excel or google spreadsheet, you can use autofilter for each club name. The club does not need to have a unique ID, as you can use already the 'club Name' as the ID. Simply autofilter the column with the Club Name and save that spreadsheet as another sheet using the club name as its name. Then you have an instant database of clubs.

    Hope this help. Please inform us if you have further inquiry.

    Thanks.

  • Profile Image
    partyrockersvip
    Answered on September 03, 2012 at 07:32 PM
    1. Question what if the customers tries to do this from there data cell
    phones (androids and iphones) what are the keys for control shift to select
    more clubs (How does that work?) what keys on cellphone should they use to
    select more clubs?
    2. I click link of clone you made (
    http://www.jotform.me/form/22467376446462 ) of my clone did you make
    changes to my clone as well? Could you just update my clone with the clone
    you made of my clone please.
  • Profile Image
    jonathan
    Answered on September 03, 2012 at 08:20 PM

    Hi,

    1. To my knowledge, most mobile devices support key inputs already capable of emulating that of a keyboard... So, I think this will also work. Most notably QWERTY input type have such CTRL or SHIFT key equivalent.

    2. I would rather suggest you clone my form instead. =) It takes no penalty on your account, and we will be teaching you better how to use the form builder if we do that.

    Here is a guide -How-to-clone-an-existing-form-from-a-URL

    And here is the URL of my form http://www.jotform.me/form/22467376446462

    Hope this help. 

    Thanks.

  • Profile Image
    partyrockersvip
    Answered on September 03, 2012 at 09:02 PM
    Hello again, LOL
    I'm sorry could you put my nightclubs and pool parties drop down back to
    its original way i had it before the changes today. I just realize its not
    going to work to select more than one club for administration purposes . (
    Also I don't understand the time box beside the date.) What I wanted was
    basically an If-then statement or a condition when the time strikes 8:30 PM
    a popup box pops up and says all Guest List is closed for today if they try
    to guest list at 8:30 PM.
    Also I notice new form on my site after using it it goes to another
    different form could you test out before making changes again please:
    http://www.MrVegasVip.net
    Thank you I hope I'm not driving you crazy!!!
  • Profile Image
    jonathan
    Answered on September 03, 2012 at 09:15 PM

    Hi,

    As you had only cloned my form, your previous form is safe and serve as your back-up copy. So no need to worry about that.

    You can again re-embed the form in your website using your original form (this http://www.jotform.us/form/21523669426154)

     

    What I wanted was basically an If-then statement or a condition when the time strikes 8:30 PM a popup box pops up and says all Guest List is closed for today if they try to guest list at 8:30 PM.

    Unfortunately this is not possible on the form builder alone. To achieve this, you will have to resolve to custom programming on your end and apply the application to the form. It will be an application capable of reading time and applying a logic conditions base on the time.

    Please inform us if you need assistance.

    Thanks.