Pinned Discussions
Forum Widgets
Recent Discussions
problem populating relationship field from import
In a new QB app we created, we have a table "Phishing Attempts" where we want to create records by importing a spreadsheet. We also have a table "Targeted Users" which has employee info such as Employee ID, email, position, etc. Phishing Attempts table has a relationship with Targeted Users table, where we have the Employee ID field from Targeted Users included in the Phishing Attempts record form along with lookup fields that are automatically pulled from Targeted Users table. The spreadsheet we want to import to create new records in Phishing Attempts table includes an employee ID number. When we import the spreadsheet, we select the target field Employee ID in the Phishing Attempts form. The problem is that the Employee ID field in the Phishing Attempts form is not populating when we do the import. The ID number in the spreadsheet matches exactly what is in Employee ID in Targeted Users table. Is this not working because the Employee ID field in Phishing Attempts is pulling from Targeted Users table? Is there a way to get this to work?0likes2CommentsInvalid entry error when entering a negative number
I have a numeric-currency field that I am using to adjust a total field. If I edit the record to enter a negative number I get an error Invalid entry. But I can enter a positive number, save and reopen the record, edit the field to add a "-" then it works. So why won't it accept the "-" on the first attempt? Why must I enter the positive value, re-edit, add the "-" in order to make it work?Solved0likes1CommentFile Attachment Naming
Does anyone have a good way to add a file name to a file attachment? When in the field and we click the 'add file attachment' button/ link, we usually take a photo with the ipad to embed there. Is there a better way than making a text field for naming? Any way to do this manually?0likes1CommentBar Chart based on Multi-Select Text field, but without unique combinations
Is there a good way to show the # of records where each option from a multi-select text field is selected WITHOUT showing every single unique combinations. For example, if Option A is selected on one record, Option A AND Option B would NOT be a separate bar on the bar chart, it would just show the actual choices in the field.0likes1CommentDefault column widths on embedded reports obscuring data
We're building a new app with the "new" form builder for the first time, and seeing an issue with embedded reports. The default column width on the embedded table reports is partially obscuring the data, and although you can manually expand each column, there doesn't seem to be a way to make those column widths stick. Am I missing something, or is this a deficiency of the new form UI? We have half a dozen apps using the legacy UI with dozens and dozens of embedded tables, and this has never been a problem. Fwiw, I found the following post describing the same problem on dashboard pages, but this is not a dashboard page. It's happening on the 'main form' within our tables... https://community.quickbase.com/discussions/quickbase-discussions/can-you-set-column-widths-for-reports-in-the-new-dashboard-pages/19595 Thanks in advance for any insight.Solved1like7CommentsPipeline formula for user names
I need a pipeline to populate a field in a new record with the names from another field. Many users did not update their profile with a ‘Screen Name’ so I can’t use that field in the pipeline. I am having trouble getting it to populate using the First and Last Names. What formula can I use in Pipelines to create a list of multiple names? I used this field to create a text field and this is what is returned: Using this text field is not ideal as Barb does not have a screen name so it defaults to her email address. If there are several users, this field will be harder to read with emails being used. I want the pipeline to take the Fundraisers Assigned values and populate like this – preferably comma separated but semi-colon is fine too. Example: Amy Gosz, Barbara Burns I can get the First Name and Last Name to combine but then it only returns one of the names. How do I write the formula to not only combine the First Name and Last Name, but also list the multiple users names? I need all names (can be several) that appear in the Fundraisers Assigned field to populate to the new field.0likes0CommentsUsing RegexReplace()
Does this function support capturing groups, and if yes, how does one access the captured data? Intent is to use a this function looking for punctuation from a text field, and then add a new line to this. regex: ([.!?])\s* substitution: $1\n Documentation doesn't state one way or the other. I've tried escaping the new line value without success. Perhaps I'm just missing something simple.0likes2CommentsTable Navigation Experience Request
Not sure where to post/send this, but I would like to request a modification to the user experience when editing records from the table home page. When you click on either the pencil or eye icon to edit/view a record and then you save/cancel and close you are taken back to the very top of the table. This is fine when you only have a few records, but when you have several pages, it is frustrating to have to scroll back down the table to find the place where you left off. Would appreciate a way for it to remember where I left off and then return me to that location. Just a thought.0likes1CommentRemoving Invalid Characters for File Name
Good Afternoon, I am trying to manipulate a simple text field to remove the following characters: \ / : * ? " < > | So that I can use it for file names. When I try SearchandReplace, it keeps throwing up syntax errors for these characters despite my double quotes around them. Is there a way to get these characters removed to prevent any file upload issues due to file name? Thank you for the help!Solved0likes2CommentsAPI not deleting attachments
Hi all, hoping someone may be able to assist. Am using a pipeline to remove attachments using the format of 'fid_14=&delfile_fid_14=1' The result of this is that whilst the attachment looks to be removed from the form, it still is actually being stored (app file manager shows the attachments still exist). Has anyone else encountered this or possibly have a solution ? Cheers in advance.1like2Comments