ContributionsMost RecentMost LikesSolutionsRe: The next generation of the Quickbase APII've been added to the beta program some days ago and filled out the survey. Is there another email I should have received on details about the Restful APIs and what configurations and addresses I should use to beta test with? Thanks!Re: Text-multiple field - Maximum input valuesThanks. Mostly you gave what I was looking for. Seems there is no real max, but it will affect performance, so it's best to generate a "best practice" when deciding on the number of values you add into this field compared to using a table relationship instead. ------------------------------ Ryan ------------------------------ Text-multiple field - Maximum input valuesFor the field type called Text-Multiple Choice, how many values can be stored in the Input Type when the "From List" is selected? Is there a maximum noted anywhere as I'm not finding it. Not sure if the max (if there is one) changes based off the type of values you store either. Thanks ------------------------------ Ryan ------------------------------ Re: Delete File Attachment with API_EditRecorddid the same thing the other day. join the bandwagon! haha.Re: Using a Formula, be able to search for a value in a field across all records of a tableOkay, that works. thank you. Apparently, when this was tested a while ago, it was stated that the checkbox for marking as unique did not work as expected for blank values.Re: Using a Formula, be able to search for a value in a field across all records of a tableWe'll look into that again today. We had a programmer check the unique field earlier and likely based off your comment, we should double-check that unique featureRe: Using a Formula, be able to search for a value in a field across all records of a tableSpecifically, I have a form with several fields on it for a table. One of those fields has a unique alphanumeric code we type in that should only be used "once" in a record. Now the records already have the record id that is being used on all the parent-child table relationships. We were going to just check the box called "Must be unique" for this alphanumeric field and call it a day, but the issue is that we also need to allow this field to be blank too. Not just for 1 record, but to allow many records to have this field be blank and pass. We couldn't figure out a way to do that ... have a field contain only unique value if it is entered in, yet allow blank values if they are not. The only way we seemed to be going towards is a lookup against that field, but it makes the whole form sluggish and useless. We're trying to do this in a form because we want it so when a user decides to type in a value into this field, the form will block the save if that value already exists in another record as being used. If the user decides not to attach a value to this field and leaves it blank, then it will save.Re: Using a Formula, be able to search for a value in a field across all records of a tableHoping there might be some thoughts on this question still. Through some more testing, I found that by doing the following, I kind of get the result I need, but it's extremely slow, so still looking for help. * create a new multitext field in which the Input Type is populated from a source field in the same table. * the source (main) field is from the same table, allowing this new lookup field to now show all the values in that table for that source (main) field. * I unchecked all the boxes under the advanced header, thinking it might help speed it up? * on the form, I created 2 dynamic rules. * rule 1: when record is saved and the main field has changed, change the lookup field to match this main field on the form * rule 2: when record is saved (after checking), see if the lookup field matches the main field. Also check if the main field is not empty (since empty ones are allowed). abort with a message that the value from the main field already exists in the lookup. This seems to work when I have the lookup field displayed on the form (which I don't want), yet it makes the form ice slow!!! basically not functional for users who don't want to wait 1-2mins. If I remove the lookup from the form, then the rules don't work it seems. Anyways, I'm messing with that still, but hoping someone might know of a way to handle the actual question. ThanksUsing a Formula, be able to search for a value in a field across all records of a tableThis may be an obvious, or maybe it's a form of searching that isn't available? There are ways in Quickbase to just get a summary of a table, grouping fields and counting the results to display in a report. Is there a way to search for a value in a field across all records of a table and then use that counted value within a formula or form rule? If not the same table, what about with related table, BUT including records in the child table that are NOT related. For example, find all records (non-related) in a table by searching a status field for the word "active" and returning that count to be used with another formula or within a form rule somehow?How to stop user(s) requesting permission to create applications billed to the accountWe are periodically getting an email from users stating they are requesting permission to create applications billed to the account. Checking in with one of the users, the request to create an app came as a popup on the screen. The popup is exited out (clicking the X), though the user has to click several times to close it. These are not desired requests, yet as the account administrator, we receive emails that the users are requesting it. It seems this is an error with the popup if they are not actually making the request. Is there a way to disable this popup for the users from randomly appearing? I'm not sure yet what this looks like. Hoping it's an easy solution to resolve. Thanks!