class='Vibrant Success' in a different colour to green!
HI, I'm using the 'Vibrant Success' button in my text formula fields (as per the Magic Buttons Sample App), and absolutely love them. However, I'd really like to use a different colour in some instances for contrast. For example, the dark blue with white text 'submit a question' button on this forum would go down a treat! Can this be done without resorting to image onload techniques? David ---- Example of the kind of formula text field I'm talking about from the 'Magic Buttons' app. If([Checkbox] = false, "<a class='Vibrant Success' href='" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#] & "&apptoken=d9eascudwjxs2sesxkjccwgtq9r&_fid_101=1&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#]) & "'>4B. Check a checkbox then display record</a>", "<a class='Vibrant Success' href='" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#] & "&apptoken=d9eascudwjxs2sesxkjccwgtq9r&_fid_101=0&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#]) & "'>4B. Uncheck a checkbox then display record</a>" ) PS Anyone not sure what I'm talking about here - search in the App Exchange for 'Magic Buttons'29Views0likes10CommentsFilter parent records within child record grid edit based on other parent selection
Hi all, I've implemented solutions similar to this in the past (filtering child records based on grid edit overrides & forms, etc), but I'm really struggling to figure this one out. Here's the scenario: I've got a table "jobs", which is a child table of "venues". On the Jobs form, I need users to be able to select an on-site contact from a list filtered based on their selection of a grandparent "venue" record. Currently, I've got a table "contacts" which is a child of "venues". I've created an intermediary relationship table "on-site contacts" which is a child of both "jobs" and of "contacts" to connect the two. I've tried adding a grid-edit child record report of "on-site contacts" to the jobs form, and attempted to filter it so that it only shows records in which "contact-related venue" is equal to "job-related venue", but with the grid edit report, job-related venue does not populate until the form is saved and the child record is officially created. Does anyone have a solution to accomplish something similar? I suppose I could flip the relationship and try and make on-site contact a parent of jobs, but I'd like for users to be able to add multiple contacts as needed. Thank you! #Gridedit #Search #filters #Many-to-Many ------------------------------ Elena Larrabee ------------------------------12Views0likes5CommentsWildCard Search in Tables
Is it possible to do a wild search in regular table view? Let's say I want to search for pras* + eggs or egg + olive Prashant is my name Prashant eats eggs with butter Prashant goes for rock climbing Prashant makes eggs with olive oil ------------------------------ Prashant Maheshwari ------------------------------7Views0likes3CommentsSearch File Attachments
I have a file attachment field and have uploaded a MS Word doc. I want to be able to search that Word doc for keywords. If I understand it correctly, that is possible in QB. I have done the step of going into the advanced settings of the table to click on "Index file attachments for use in searches and report filters" as per the instructions. But it doesn't seem to be working when Ido an advanced search and look in "some file attachment" for a keyword. Is it possible to search in file attachments as I outline above? or am I missing something? Jeff ------------------------------ Jeff Elliott ------------------------------7Views0likes5CommentsIs there a way to search multiple records and open multiple records with one button/click?
Hi there, I am wondering is there a way to search multiple records and open multiple records windows with one button/click? Thank you. I am asking this because a colleague needs to update some fields of multiple records, could be dozens or hundreds. Those records could be randomly picked, hard to cover all of them by creating a report by single or multiple field properties. 1. He wants a search box can paste all the record names one time and get a list of these records. 2. Even there was a report for him and he knew how to use Grid Edit, he still wants to open all records windows at one click. Is it something possible? without advanced API and developer function. Ning ------------------------------ Ning W ------------------------------7Views0likes12CommentsHome Page Search Bug
Hi everyone, I'm having a bizarre issue with the home page search function, and I'm not finding any other reference to anything similar on the community. Apologies if I missed another discussion already posted about this. I have a search bar on a home page that is supposed to search and display results based on a certain report. For my admin role, this works perfectly. But for every other user, it defaults to the reporting defaults for the table and searches every single record regardless of the filters applied to the report. Has anybody else experienced this? I did also have a user test it for me on their account to verify that it isn't some strange thing that happens when I "test as user." #Apphomepages #Search #Userandgroupmanagement ------------------------------ Elena Larrabee ------------------------------Solved3Views0likes4CommentsSearch in a range
Hiya, I have a table with a number ranges connected to a customer, and I need to be able to search and return an answer if a number is identified within that range. For example, a customer has the phone number ranges between 8907000 and 89070100, meaning they use all the numbers between 8907000 and 89070100. If I do a search on the number (ie) 89070050 I would expect to see this customer data come up. Can anyone explain how I do this. cheers . ------------------------------ Peter Earle ------------------------------2Views0likes1CommentDynamic Filter on multi select field, And not Or
When using a multi select field for one of your dynamic filters, it essentially uses an 'Or' function. So, if my field is Colors, and I have 'Red,Orange, Yellow, Green, Blue', and in my dynamic filter I choose both Red and Orange, it will show me all records that have Red OR Orange Selected. Is there some sneaky way to make QB treat this like an And function (presumably with some creative formula field)? So if I select Red, Orange in my dynamic filter, it only shows the records that have Red AND Orange selected? ------------------------------ Michael Tamoush ------------------------------2Views0likes1Comment