QuickBase Questions, FAQ’s, and API Support

If you have a question about QuickBase, the use of the api in particular, please ask in the comments of this post. I will update this blog post to include your question and my answer so that others who come across my site can see it. Many of you have been emailing me GREAT questions that I would love to share with the rest of the QuickBase community.

Any questions about QuickBase are open game, but my speciality is with the QuickBase API. If I don’t know the answer, I’ll find it and/or get you in touch with someone who can.

This is not an official alternative to contacting our support at http://quickbase.intuit.com/support/. You should still contact our support team if you have any urgent or business-critical inquiries.

1. How can I create a web form to let a user edit and add records in QuickBase?

I have a custom form, created with the QuickBase custom form wizard, which anyone can use to add a new record to my table in my QuickBase application.

Ideally, though, I would like users to be able to edit existing records with the form. Unfortunately, I have only found commands that point the form to edit existing records. Is there anyway this form can edit the form if some of the fields match? E.g. The name field in the existing record is ‘Joey’. When the user enters ‘Joey’ into the form, it would automatically point the edited record to edit the entire record that includes ‘Joey’ in the name field.

Answer

In order to do this, you would need to invoke either javascript or process the form via a backend script (like PHP) to handle the logic of whether or not to do an add_record or an edit_record.

I’d recommend you host the form yourself on your company’s website (if you aren’t already) and use the api for processing the form. Doing this gives you more flexibility in what you can do with the data that is submitted and what records are affected.

Published byJosh McGinnis

Josh is a software engineer, leader, startup advisor for the LA Chamber of Commerce and consultant residing in the Los Angeles area. Josh is passionate about helping entrepreneurs and businesses reach their maximum potential.

3 Comments

  • Ron Stevens

    September 18, 2009 at 1:51 pm Reply

    Would like to expose the data in quickbase to a sharepoint 2007 solution.

    Trying to eliminate double data entry.

    The client would add the info into Quickbase and I would be able to access the info via a data connection (Web Service?) of some type.

    The ulitimate would be a two way sync in case info changes on the Quickbase side SharePoint would be updated.

    Is this possible and do you have any interest in working on it?

    Thanks

    Ron

  • Medikal sistemler

    July 16, 2010 at 11:30 am Reply

    Thak you ….

  • Mahesh

    July 20, 2010 at 5:10 pm Reply

    I would like to get some specified data from Quick base and need to publish in sharepoint for the status information purpose…Please suggest us if there is any work around for this…

    Thanks
    Mahesh

Post a Comment