Recent Discussions
How to consolidate multiple rows into one
Hello, Is there a way to consolidate multiple rows into one row? I have Table A right now. The Site ID column is the key column for the table since it’s a numeric field with unique values. I know about creating a relationship and then creating a summary field but I don't think it would work in this case because I want to use the Account ID column to summarize instead of the Site ID column. The only columns I'm interested in are the ones in the red square. Basically, I want to extract that data and consolidate it using the Account ID field and then have all the different Account codes related to the Account ID in one cell (like Table B). I don't mind if it has to be in a separate table. Is there a way to do this? Table A Table B0likes7CommentsPipeline Advanced Query multiple conditions
I have a pipeline I'd like to trigger based on conditions from multiple fields. These conditions work separately but I'm not able to get them to work together. I used the syntax provided on this page: Quickbase Help I need to use a query instead of the built in conditions because the first condition requires 2 date fields to match each other. {35.ex.'_fid_7'}AND{36.ex.'true'} ------------------------------ Anne Martin ------------------------------0likes6CommentsIs there any way to show an embedded report with all the records related through a summary table
There are three relevant tables in this scenario, Projects, Groups, and a summary table called Project Groups. There is a one to many relationship from Projects and from Groups to the Project Groups table. This is to allow a project to be a member of multiple groups, and a group can contain multiple projects. I would like to show an embedded report in the projects form that shows all of the other projects (with some other relevant fields) that share a group with the project I am viewing, and I plan to group that report by Group. Is there a way to accomplish this?Solved0likes6CommentsDisplaying Values in Proxy Field
I have a Text (reference proxy) field that displays the values of a table via a relationship. The table has two fields "Brand" and "Percent". I have successfully created the table relationship and the dropdown is showing the values as expected. The issue I am having is when I select a Brand name the Percent value goes away from the dropdown after selecting it. Is there a way to display both the "Brand" and the "Percent" after value selection?0likes6CommentsAmbigious Pipeline Error?
I have created a pipeline with several steps, I have one step that saves a pipeline object which is just saving my api respond and that seems to fail inconsistently while it works other times. The error I get is Something went wrong executing a step. Try modifying your pipeline. What issues could cause this? Could it be a timing it issue in regard to it having to wait for the response?0likes1CommentUsers are overlapping times on same date
Okay I have a user field a date field, time mobilized field, and a end time field. I need a message to pop up letting the user know if they put overlapping times in, that they need to adjust their times or have another user take care of the issue. How can I do this? Thank you all who take the time to help!0likes7CommentsFilters Removed when adding a column via "show more columns"
With "new style" table reports, if I apply dynamic filters or use the search bar to filter the report, and then add a column (by hovering over a column header, using the "..." then choosing "show more columns" and hitting "apply"), the column gets added but all those filters get removed. The search term remains in the search box and dynamic filters that were applied stillappearto be selected in the UI (shows selected still at the top) but they are not. The filters are removed, and you have to clear and re-apply your filters. It trips me at least once a day and it's driving me nuts...I put in a support case in April, eventually QB closed it and said they tied it to a bug, but I can't be the only person that this is bothering... I understand that QB is probably/hopefully working on this and I just need to be patient. I guess I'm just looking to commiserate in the meantime with any else that is getting really annoyed about this. Can I get an AMEN??2likes1CommentAll Fields not appearing in Pipelines "Select Fields to Specify Values"
I'm trying to create a pipeline that will create a new record in my decisions table if a new record in requests is created. Was able to set up the On New Event section, but when I then try to set up the Create Record section, the fields I need to specify values (Approver Name, Approver Role) are not options. What do I do so I can make those fields options/selectable? Kim0likes9Comments