ContributionsMost RecentMost LikesSolutionsText as Key Field.Hello, I'm using a Text as a Key Field - [Charge Code] The issue I'm running into is that whenever i change the [Charge Code], it disconnects the child records associated with it. How can i make it so that the Related Charge Code for the child record updates when the Parent's Charge Code is changed?Removing duplicates from a textlistHello! Was hoping I can get help with this problem. I'm using a query formula to get a list of emails from another unrelated table and it works just fine, however, it gives me duplicates which i'd like to get rid of somehow. Has anyone dealt with this issue before? example textlist: brucewayne@email.com ; theflash@email.com ; brucewayne@email. com ; brucewayne@email. com ; theflash@email.com; theflash@email.com ; superman@email.com desired outcome: brucewayne@email.com ; theflash@email.com ; superman@email.com I can either make a new field to get the desired outcome or perhaps there's a way for me to stop duplicates on the query formula?Re: Save and Keep Working buttonUnfortunately, both suggestions did not work for me. i have the table i'm using and the table where the report link is coming form to "auto save when redirected" but it did not work. i paired the above with the SaveBeforeNavigating class and also did not work :| edit: both still asks me if i'm sure i want to leave the page as the changes will not be saved Save and Keep Working buttonI've seen a post similar to mine but the thread was old. I am looking to see if there is a way for me to make a Formula - URL or a Formula Rich Text button that will basically mimic the Save & Keep Working button. The roadblock I'm coming across is that I have report link table (from another table, of course) in my form in which a user can select options, put notes in, etc etc. Any time i try to use something like: URLRoot() & "db/" & Dbid() & "?a=dr&dfid=2&rid=" & URLEncode([Record ID#]) & "&rdr="&URLEncode(URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl()) it's asking me if i'm sure if i want to leave as the changes will be unsaved. Is there any way for me to make a Save & Keep Working button that will save the changes in the report link? Basically, i want to press it and refresh the page as once changes happen on the report link table, i have a pipeline running. The users have to refresh the page itself to see what the pipeline has done.Hiding Empty Columns In a Report Currently, we have a lot of fields that we put on the report because sometimes the customer puts a value in those fields but is there anyway we can just hide this column if there are no values and appear when there are values. Does anyone have a creative solution for such thing? Re: report query skp-nI'm adding it to a report url on a browser!report query skp-n Hello, From https://help.quickbase.com/api-guide/do_query.html , I was able to get this to work on a report url skp-n --skips the first n records returned by the query However, it seems to only skip pages if i switch the old Table UI. Is there anyway to make it work to skip on the new Table UI? possible report link mistakes Hello, I'm somehow having a problem on a report link field. It was working then it stopped and im not sure what went wrong. Two apps. The first app has a Steps table, these steps are related to a Task table in the same app. On the Steps form, the user can click a url button that then goes to the 2nd app and fills in some information that i use as a unique value to set up the report link e.g. the minimum record id# of a step that is related to the same Task, let's say this number is 300. The second app is for requests. In this instance, the user can request to reset a Step. The report link is for me to see the Steps the user has in a specific Task. Numeric 300 is automatically put in the form of the 2nd app, yet it doesn't show any data in the report link. I thought maybe i had to save the form but even after doing this, the data wouldn't show. I've made sure 300 is unique and the matching field and the target field is all good. What could i be possibly doing incorrectly? I've made sure the fields are both numeric, I'm an admin in both apps so it can't be permissions, and it was working before... there isn't a limit for report link fields, is there? Re: Formula for a field to label which order it is inunfortunately, there can be any number of steps!Re: Formula for a field to label which order it is inThanks for the response, Mark. This is definitely something i'm starting to move towards! However, you don't happen to have an idea on how to label the Steps that have already been done, eh?