Forum Discussion
LauraThacker
8 years agoQrew Captain
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
- GauravSharma38 years agoQrew CommanderWhat is here ridlist?
- LauraThacker8 years agoQrew CaptainI 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=...
- GauravSharma38 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"
- LauraThacker8 years agoQrew CaptainTry 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? - GauravSharma38 years agoQrew CommanderIt looks like it is because of too many fields. Yes, Grid edit feature works for me with fewer fields.
Thanks,
Gaurav - MCFNeil8 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