FrancescoSpiga1
Qrew Cadet
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: 2 Very Large Mobile Issues, anyone agree?
Agree on both points. I know the team in Bulgaria, Sofia is working on a massive revamp of the mobile app. Allegedly, they are going to release the new features in 2023 (Q1 or Q2 I hope). They have been talking about parity between desktop and mobile for a while now... I hope this becomes a reality in 2023. ------------------------------ Francesco Spiga ------------------------------5Views0likes0CommentsRe: Overlapping dates
Hi Nathaniel, I have been looking to create an overlapping report based on date/time fields as well. Is there a function in QB that can reproduce the same results of the SUMPRODUCT excel formula? Sadly, I have not found a solution yet... ------------------------------ Francesco Spiga ------------------------------29Views0likes5CommentsRe: Make a button generate a quick note
Sounds like you just need a simple API_EditRecord. Also, you need to activate the "log entries" option on the property of the field so it would keep track of who/when as well. URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" & "&rid=" & [Record ID#] & "&apptoken=apptoken" & "&_fid_id=Completed" & "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() &"?a=dr&rid=" & [Record ID#]) Replace the the values in bold with 1) app token 2) field id of your notes field Hope this helps. ------------------------------ Francesco Spiga ------------------------------5Views0likes7CommentsRe: Using a summary report to spot duplicates
I wish we could create reports out of existing reports... This would fix so many workarounds in QB. https://quickbase.uservoice.com/forums/111823-quick-base-product-feedback/suggestions/40133761-table-report-out-of-existing-reports ------------------------------ Francesco Spiga ------------------------------17Views0likes0CommentsRe: How can I create a formula to count the number of times a field has been modified?
What if the Attachments are saved in a separate table? How do you get the count? (excluding the summary fields here, as the file will be replaced and not added in the child table) ------------------------------ Francesco Spiga ------------------------------46Views0likes0CommentsRe: Save and keep working + trigger an API on same record (Edit Record)
For the records, I ended up using the below: var text url = "javascript:DoSaveAdd()"; "javascript:" & "$.get('" & $url & "',function(){" & "location.reload();" & "});" & "void(0);" 1. I change one of the fields with a form rule (Status = NEW to PENDING) 2. I post a child record with automation (who submitted the request and when) 3. Page refreshes and shows the child record (JS location.reload) Table Advance Settings - Make sure to check the option : "Save parent record automatically when a child record is created." one click. mission accomplished! Thank Adam!21Views0likes1CommentRe: Save and keep working + trigger an API on same record (Edit Record)
I still have the issue of saving the records once the form rule gets triggered. I am going with the automation for right now... I'll keep messing with the rich text field... I'll post something If I can get it right.29Views0likes0CommentsRe: Save and keep working + trigger an API on same record (Edit Record)
AustinK, that would work but then I'll have to refresh the page to see the updated record - the automation lags compared to APIs (not a big deal anyway, this could work) Adam Keever, Thanks for the suggestion. I'll check out the magic buttons and see if I can make it work the way I want. My problem is that the record has not been saved yet... I want to save the record and then trigger the API or automation and display the updated record...29Views0likes0CommentsSave and keep working + trigger an API on same record (Edit Record)
I am trying to combine the below code (copied from previous conversations) with an API_EditRecord "<div class='Vibrant Success' onclick=$('#footerSaveAndKeepWorkingMenuOption').click();>SAVE AND KEEP WORKING</div>" I need to: 1) Save the record (the above code will do it) 2) Trigger an API that will edit the record I just saved Can this be done with one button click? Will this work on the mobile APP? Any help will be greatly appreciated.45Views1like9Comments