Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

error: Error updating 'Tasks' column in request <request_id>: Insufficient permissions to create new select option ""Financial Assistance for Groceries"" #66

Open
elowing opened this issue Aug 7, 2020 · 1 comment

Comments

@elowing
Copy link

elowing commented Aug 7, 2020

Hello friends! I'm helping a West Philly mutual aid group transition their existing Google Form -> Google Sheet workflow to your Airtable/Slackbot setup. As a result of their already hefty request database, I don't think I can start fresh with your Airtable template. I copied a sample of their data over from Sheets to Airtable, and have been renaming their old/adding new columns to match your table's fields.

However, I am getting consistent Task errors when running make develop locally, as mentioned in the issue title. My Tasks column has options for:

Grocery shopping
Financial Assistance for Groceries
Picking up a prescription
Financial Assistance for Prescription
Transportation to/from a medical appointment
Dog walking
Loneliness

But the server consistently throws: Error updating 'Tasks' column in request <request_id>: Insufficient permissions to create new select option ""Financial Assistance for Groceries"". Any ideas why it would be trying to create a new select option? Also, I'm pretty sure it did create the new Financial Assistance... select options, b/c I think we copied your Airtable template over before you updated the Task wording. So the ones I manually added were the older wording, and your app was able to add the new ones.

I'm not sure what's wrong, but I think it's causing no tasks to be returned for a given request. Trying to track down why it's trying to create a new select option when that one now currently exists. Any guidance would be greatly appreciated. Thanks in advance.

@azlyth
Copy link
Member

azlyth commented Aug 7, 2020

Hey friend! My guess is that the Original Tasks doesn't have the same choices as Tasks.

When a task comes in with multiple tasks selected (which gets split up by the Slackbot into several tickets), the Original Tasks column is used as a data backup of the original set of tasks.

Let us know if that works, we're here to help.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants