Forum Discussion
Laura_Thacker
9 years agoQrew Commander
I did a quick test and built a formula-URL button with this format and it launches my pre-built report with custom-report-column properties set.
URLRoot() & "db/" & Dbid() & "?a=q&qid=6&dlta=mog~&ridlist=61893&qskip=0&navBack=true"
which generated my report looking like this. The age formula column has a space between the field name and the __________, hence the splitting
URLRoot() & "db/" & Dbid() & "?a=q&qid=6&dlta=mog~&ridlist=61893&qskip=0&navBack=true"
which generated my report looking like this. The age formula column has a space between the field name and the __________, hence the splitting
- GauravSharma39 years agoQrew CommanderWhat is here ridlist?
- Laura_Thacker9 years agoQrew CommanderI don't think you will want the ridlist in your formula; since each time I generate the report from a different Record the ridlist changes. I took that out, and the button still functions the same. https://laurahillier.quickbase.com/db/bhfdbnjwq?a=q&qid=6&dlta=mog~&qskip=0&navBack=...
- GauravSharma39 years agoQrew CommanderLaura, It is not working for me. I don't know why? Maybe I have around 120 fields.
Here is my formula for your formula:https://elevateservices.quickbase.com/db/bmqar9tmq?a=q&qid=8&dlta=mog~&qskip=0&navBack=true"
- Laura_Thacker9 years agoQrew CommanderTry a version of this with say 20 fields, or less and see if it works. I think that QuickBase Support would tell you that 120 fields in a single report is simply too many.
Does the Grid Edit feature work without trying to customize your field headings? - GauravSharma39 years agoQrew CommanderIt looks like it is because of too many fields. Yes, Grid edit feature works for me with fewer fields.
Thanks,
Gaurav - MCFNeil9 years agoQrew CaptainIf you have more than 20 fields that you are using for grid edit entry, I'd say you are doing something wrong with your data structure or entry method. Just my 2 cents