RussellBeaubien
Qrew Cadet
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: timeline temporary report not filtering correctly
The users are looking at the relevant project I want the button to give them the right information. I could set it to be the way your saying but then the users would have to go to another table and filter it down, instead of pushing one button ------------------------------ Russell Beaubien ------------------------------timeline temporary report not filtering correctly
Currently I am setting a time line report for a project to create a Gantt chart. How I have it setup is a projects will have multiple PO's to different vendors. On each PO I can create multiple Gantt entries. From the project I hit my formula url button to make a temporary report of all Gantt entries. URLRoot() & "db/" & "table ID" & "?a=q" & "&qid=5" & "&query=" & "{'15'.EX.'"& ToText([Project Number]) & "'}" When I change "&qid=5" to 1 to use the list all report the filter I have in my formula works correctly. But when it is set to "5" which is a time line report, the filtering does not work. ------------------------------ Russell Beaubien ------------------------------API Call add and update records in one function
Currently I am importing a file into an existing table matching to records based on the KEY field I made ("customerID-Invoice#"). There are hundreds of records in this file, some do not match the QuickBase KEY field properly So when I manually import it creates a new record. I want to start using an API call but I noticed there is "Add_record" or "Edit_record" function. So, If I use "Edit_record" for API call and the KEY field ("customerID-Invoice#") does not match what will happen? 1. Create the new record 2. Nothing 3. Error msg and no records get updated Or is there a different function for the API call I should use? ------------------------------ Russell Beaubien ------------------------------Re: How do I Default back to old style of Table Report -
I had the same Issue. One table I tried the "New style (Beta)" didn't like it. So I turned it off. Now every time I go to any table its always new style first and i have to turn it off for ever report on every table in every app ------------------------------ Russell Beaubien ------------------------------Child report on parent record to show photos
I have a parent table "Projects" with a child table of "Supporting Documents" When viewing a project record I have a table for the child showing all linked supporting documents Allot of the supporting documents are photos and I would like to have a thumbnail view in this table instead of IMG_****.jpg FYI: [Document File] is where the attachment is. ------------------------------ Russell Beaubien ------------------------------
