Forum Discussion

AndreaTyler's avatar
AndreaTyler
Qrew Member
8 years ago

Is there a way to import data from Quick Base into Outlook?

Is there a way to import data from Quick Base into Outlook?
  • ChadBrandmire's avatar
    ChadBrandmire
    Qrew Assistant Captain
    What kind of data are you looking to send? I'd imagine that it could be done through Notifications. Or just creating a URL button on the form. Plus there is the ability to export to different file types.

    Will need more information about what you're trying to accomplish to be helpful 
  • Update: In late 2021 the ICalendar field type will be reaching the end of support and this post includes information on this feature. While the End of Life date has not yet been announced the ICalendar field type is scheduled to be retired. We recommend using the pipelines outlook channel instead, it will allow you to more easily sync calendar events between Quick Base and your Outlook calendar and so much more.

    [Learn more about: Quick Base’s general approach to retiring features | iCalendar retirement | Replacing your iCalendar fields with pipelines]

    There is an iCalendar field that can be added to a table and then a form.

    A few notes: adding a start date, start time and finish time and then a formula that concatenates the date and time together for start and finish, allows you to autofill the ical date/time.
    If an address field is used, add a concatenate formula for the address so it is all one line. The ical can handle this more easily.

    default values for an ical without start date and time are the current time and date on the computer for start and 1 hour later for finish.

    Lastly users will then have to use scheduling assistant to add additional users.

    Alternatively there is API logic for Outlook/O365 that can be found on the MS website. You would want to find an intermediary like Workato to watch for changes and transfer data. Or you can create a button with the API and fid's, or a page... I have not done any of these things yet but know it is possible with enough time or money.