Forum Discussion

LandonWyrick's avatar
LandonWyrick
Qrew Member
2 years ago

External Form for Non Users

Hello,


I am trying to create a form that a non user within my company fills out that will then create a record in an app I have in QuickBase. I made a Google Form and used Zapier. The new record was created but no fields had the data in them. 

I also attempted the EOTI, but that is just a little above my abilities/ knowledge. I have the HTML code but do not know where to go from there. 

I then tried pipelines... which these seems like it would be the easiest thing to achieve since I already have the Google Form, but I don't have the option to create a new pipeline. 

I would greatly appreciate assistance and some advice on which route is best and what I need to do to make this work. Thank you in advance!

------------------------------
Landon Wyrick
------------------------------
  • EOTI will be the easiest way to go. 

    In general you create a table for the input form and allow everyone on the internet to access that table.  The EOTI users should be able to add record but not edit and not delete.  You create the regular input form for use in Add Mode and then have an alternative form with just thank you words for viewing records.

    There are some other best practises tips are previous postings in this forum and if you pursue the EOTI method and wanted some advice to make the forms a little prettier then we can continue our dialogue here.

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • LandonWyrick's avatar
      LandonWyrick
      Qrew Member
      Got it! I have the table already created... how do I make it available for anyone to make an entry?

      ------------------------------
      Landon Wyrick
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        Crete a role called for Example EOTI. Set the permissions.

        The go to add a user like you would normally do - blue button to Share with new user and literally start to type

        everyone on the internet 

        into the box and it should come up as a choice.  Assign those 6 billion people to the EOTI Role.

        If for some reason you don't get that option to come up it's possible you'll have to put in a support ticket and ask Support to enable your app for EOTI Access.

        ------------------------------
        Mark Shnier (Your Quickbase Coach)
        mark.shnier@gmail.com
        ------------------------------