DeepaPrashant1Qrew Assistant CaptainJoined 7 years ago60 Posts8 LikesLikes received1 SolutionView All Badges
ContributionsMost RecentMost LikesSolutionsChoosing a parent from a child table My parent table is "Change Requests" and child table is "Prompts." The prompts tables houses prompts to a chatbot and the Change requests table houses all change requests (bugs found, knowledgebase expansion etc) that stem from prompts that have a negative feedback. So each prompt could have a change request. I created a Related Change request numeric reference to link the two tables and a corresponding Change Request (Text (reference proxy) ) and this allows me to look up and choose a parent record to assign the child to. However, I first need to create the parent record before it shows in the drop down menu of the Change Request (Text (reference proxy)) field. Further, I would like to filter this drop down to only show Change requests related to that particular Bot (as the Prompt table houses data for multiple Bots). Is there a way to create a new 'Change Requests' record from within the Prompt's table? I have Prompts collected for two Bots - Is it possible to filter the Change Requests drop down in the Prompts record to only show the Change requests related to that particular bot? Thanks! Deepa Re: Open beta for grid reports has begun! I love the concept but the visuals need to be improved. I like the old grid edit report look better. The header had a gray background with the headers in white showing prominently and the header wrapped itself and so did the data in the column. Now nothing is readable as nothing wraps and columns to the far right can not even be expanded as one cannot reach the edge of the column to capture and expand. For now, I have reverted to the old grid edit. Re: Filtering Summary Reports Hi Mark, I am trying to do something similar but it doesnt involve different tables. The summary in my case if just a count of the number of prompts in a category and Category is just a text field in the table called 'Prompt.' So a summary report, counts the number of prompts in each category and I am also calculating a % in the next column. So I have three columns : Category, # of Prompts, % of total. I want only the top ten or don't mind filtering by percentage. But how do I call upon a summary column to filter? Any help or guidance will be great! Re: Use AI to create a field based on another text field This worked! Thank you. I did run into issues of reaching the maximum allowed limit :Validation error: Daily resource limit exceeded for: ['output_tokens'] But thats a different issue. Use AI to create a field based on another text field Is it possible to use AI to create a field "Category" based on another text field "Description." The field description is of-course is verbose and all over the place. But technically LLM should be able to create a succinct 'Category' field for me by parsing the actual topic of discussion captured in the description field. Is this possible within Quickbase? Re: Find and append new unique values to secondary table Hello, Was this ever resolved? Thanks Deepa Re: How to add a link to new notifications? I have the exact same use case. Re: Trigger RULE is there is a change in an attachment field Thank you Mark! You are a savior as always! Trigger RULE is there is a change in an attachment field I have RULE that says when "Ready for Approvals" is checked and an attachment has been added, it triggers an email. Now I want that email to be triggered again if the attachment is modified, that is someone saves over the attachment again (they may or may not change the name). How do track that an attachment has been modified? Thanks! Deepa SolvedRe: Getting stuck on this form rule... So the solution was to create a new formula field that removed any spaces from its answer as the empty spaces were being read by the rule as not being blank.