ContributionsMost RecentMost LikesSolutionsRe: Broken Conditional Dropdowns After Update They are working on a solution:Bug ID#QBE018552 ------------------------------ Gerome Rich ------------------------------ Re: Broken Conditional Dropdowns After Update Me too. What i found is that if you have add your reference proxy field to the relationship again, see below, and use the second iteration, the lookup, as the first field in the conditional relationship, this works. ------------------------------ Gerome Rich ------------------------------ New Forms - Hiding Form Elements - (&ifv=0) Hi Team, Like everybody else i have been equally excited by the new forms and coming across issues. I currently use the &ifv=0 at the end of the URL formula buttons to lose all of the QB 'stuff' for some EOTI data entry elements. This doesn't appear to work for me with the new forms. Any clues? This is a URL that currently works for me, from a Dashboard that is EOTI. https://zzzz.quickbase.com/db/databaseid?a=nwr&nexturl=%2Fdb%2Fdatabaseid%44F%3Dshowpage%26pageid%3D101%20&ifv=0 WHen i try a similar URL with a 'new form' the web page just doesn't render. Anybody else come across this issue yet and/or have a suggestion? Thanks Gerome ------------------------------ Gerome Rich ------------------------------ URL Button to add a record, from a Dashboard/PAGE and select a different formHi All, I have a number an approval application that has a table of approvals, that is used for 4 or 5 different approvals. (Payment Requisition, Travel Requisition, etc.) I can do this two ways. 1. Set Dynamic Forms, so that depending on the type of approval you select, the form adapts dynamically. 2. Have four or five different forms, and have the correct form open, depending on which button is pressed. I would like, if possible to have 4 (or 5) different buttons on the home page. One for Payment Requisition, one for Travel Requisition, etc. And when pressed have an API_AddRecord with the dfid=12 field. But i can't get it to work. Any pointers. Thanks Gerome ------------------------------ Gerome Rich ------------------------------ Re: Record who presses a URL ButtonSuper Star! Thank you very much. A bit of tweaking on the & dbid ()to reference the actual table, and we were away. (for those playing at home!) Much better solution! You are a star. I really appreciate your time. Regards Gerome ------------------------------ Gerome Rich ------------------------------ Re: Record who presses a URL ButtonAwesome! Thank you very much Mark! For those playing at home, you can't use Logas a variable, so just changed to Loogand it worked perfectly. (I didn't know that, QB told me.) I just need to insert the app token into the formula and we are all good, turn app tokens back on and we are all good! The child record approach might be much better, as then we could quite easily search and aggregate data on who is downloaded what, and how much. Pointers for this appreciated. (If complicated or stretching the friendship i can live with this solution for now!) Thanks again. Gerome ------------------------------ Gerome Rich ------------------------------ Record who presses a URL ButtonHi, We are using QB as a Knowledge Hub, uploading documents from our various projects and programmes. The documents are our companies IP. Accordingly we want to be able to track who is downloading the documents as we do occassionally give access to contractors. To cover off on access restrictions we don't display the file attachment in records or reports for general users. I have a URL Button that tests that a <Restricted Access> checkbox is not ticked, and that a document actually exists. If these two criteria are met, the button appears and is able to be pressed which downloads the document. Code for the button is here: If([Restricted Access]=false,If(ToText([Attachment])<>"", URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e6/v0")) What I would like to be able to do is each time the button is pressed, record the user pressing the button in a log field. Date and time would be a bonus, but could live with just user name. Basically just need to copy Current User and potentially date to a text field, that has the <log> button ticked! Any help greatly appreciated in how we add this to the URL if it is even possible at all. Cheers ------------------------------ Gerome ------------------------------Re: Conditional Drop Down between four tables (in a square relationship)Brilliant! Works perfectly. And now I have a much better understanding about how the conditional dropdowns actually work, rather than just knowing by rote! Thank you very much!Conditional Drop Down between four tables (in a square relationship)I would like to set up a conditional dropdown between four tables. But to me it doesn?t appear to be a cascading dropdown as set up. I have no issue with regular dropdowns but this one has me stuck and I can't find a similar query here in the community. (Apologies if it is there and I have either missed it, or misunderstood it!) The relationship between the tables is: SubContract -< SubContract Lines SubContract - < Invoice Invoice - < Invoice Lines SubContract Lines - < Invoice Lines. Each sub-contract will have a number of SubContract Lines of detail against which we need to track expenditure against each. The expenditure coming in the form of invoices. When invoices come in they will have multiple detail lines in them, that will correspond to the SubContract Lines, and hence we need to be record them against the relevant sub-contract line. So when creating an invoice I want to be able to select the contract. This I can do easily. Then when I add an invoice line to the invoice, I want a dropdown that allows me to select from the lines in the corresponding contract. Cant his be done natively? Or is there a better way to do this? Thanks in advance.