ContributionsMost RecentMost LikesSolutionsRe: Quickbase Sync error: ""Received unexpected error: The operation has timed outRe: Formulas divided by 0 - nope, nothing like that in the tables I'm using. It's all text. Re: linking to new drive - That's a possible idea, but that means I'd need to re-set all my forms and relationships to the new table. I'd really rather avoid that :( Although, you're right, in the past I've also gotten very odd errors preventing the refresh from occurring for hours. Re: type of sync - It's using a connection to Box.Quickbase Sync error: ""Received unexpected error: The operation has timed outHi, I get this error semi-occasionally when an automatic refresh occurs in my table. It'll sometimes succeed, but other times fail randomly with this message. Unless I'm completely oblivious, I can't find a reference to this error anywhere. The error reads simply reads: "Received unexpected error: The operation has timed out" Is there anything I can do to debug this further?Re: Notifications: ""email addresses listed in the field"" not sendingFor anyone having this issue, the solution posted here works:https://community.quickbase.com/quickbase/topics/sending-email-notification-using-an-email-formula-f... Basically, it seems that even though Open Notifications allows you to pick the "email list" field, the email notification system that quickbase has doesn't respect the semicolon delimited list that the field generates. I think this is a bug/oversight within the notification system, but the workaround is to create individual email formula fields and list them within the "specific list of email addresses" field on Open notification page.Notifications: ""email addresses listed in the field"" not sendingHi, I have an Open notification scheduled to go out when a record changes, but the notifications don't seem to send when using the "email addresses listed in the field" option in the "notify whom" field. They DO send when I type the email address manually using the "specific list of email addresses" option though. The email field I'm trying to use is an email formula field that converts usernames to their email addresses using UserListToEmails() formula. The field is inherited from a different table via a relationship. When I create a test table with the email field in it, all the email addresses display appear correctly so I'm not sure what I'm missing. notificationWhat does ""Your permission level does not allow you to overwrite this report."" mean?I'm running across this error with users in one of my apps and I can't figure out why. The error is: "Your permission level does not allow you to overwrite this report." Users are getting this error when selecting a pre-made report, selecting 'customize', editing it, then attempting to save it. In another app I have, users can follow these exact same steps and save the report as a personal report. The permissions and UI options for the roles are identical as far as I can tell and so are the settings on the different reports themselves. I'm an administrator in both apps as well. How can I allow for users to select a report, customize it, then save their changes to the default one as a personal report?Is there a way to perform bitwise comparisons using the formulas in Quickbase?Title says it all. I'm pulling in a hex string into my dataset and need a way to perform bitwise comparisons against it. Does anyone have any experience with getting this to work by chance?Re: How do I delete a sub-set of records from a connected table?Thanks for the help!Re: How do I delete a sub-set of records from a connected table?Well I noticed some special conditions discussed for 25MB files here:http://www.quickbase.com/downloads/sync/QuickBase_Sync_for_Cloud_Apps.pdf Additionally in my own use of it, I noticed that I kept getting substantially more errors in the sync operation as the file size was closer to 25MB (operation time out errors and spools failing). For the file split, my thought of changing the settings is so that the table in QB retains all the data. Meaning that the first half of the import would basically wipe the DB and make it match that first half of the CSV while the second half would simply append to it on the table without removing anything (essentially re-combining the file prior to the split). If you believe the split may not even be necessary though, then that might save some work.Re: How do I delete a sub-set of records from a connected table?Hmm, ok so a little extra work may be needed here. My understanding is that QB sync operations are limited to ~25MB files though correct? If I re-compile all the data I need manually into a single csv, it comes out to ~40MB. So I suppose what I could do is: 1. split the csv into 2 files 2. sync the first file with the "add, update, and remove" setting selected in order to match the csv exactly 3. sync the second file with the "add, update, but do not remove" setting selected Can you see any problems arising with that approach? I really don't want to mess anything up in the database and wiping all the newer records makes me a bit nervous. Thanks for the reply!How do I delete a sub-set of records from a connected table?I have a large number of records that I've imported into a table over a long period of time via the connected tables option (with the add, update, but do not remove option set)and now no longer need to reference some of the older data that was imported. I'd like to delete these older records in order to avoid issues with running out of space, but it seems I'm unable to do so. I've checked that I'm in an Administrator role and that I have the green checkmark next to 'delete' for the table I'm looking at. What I tried to do was to filter only the items I wanted to delete in a report, click grid edit, highlight the row, right click and select "delete record". When I do this though, I get an error message that says "You do not have permission to delete items". This was the guide I followed: http://help.quickbase.com/user-assistance/deleting_multiple_records.html Is there anything else I need to enable as permission on my role to delete accounts? Could the use of a connected table be not allowing me to remove records for some reason? BONUS QUESTION: Assuming I can somehow delete records, is there a more efficient way to delete multiple records can highlighting multiple rows via grid edit? I have ~10k records that I'd like to remove...