ContributionsMost RecentMost LikesSolutionsExclude / Restrict Holidays from Date Field SelectionHello, Is there a way to exclude or restrict a user from selecting a date in a date field if it falls on a holiday. Thanks, ------------------------------ GH GH ------------------------------ Re: Custom Data Rule - Restrict Weekendsthank you Coach! ------------------------------ GH GH ------------------------------ Custom Data Rule - Restrict WeekendsHello, Does anyone know if a custom data rule can stop a user from selecting a date that is on a Weekend? Thanks ------------------------------ GH GH ------------------------------ SolvedRe: Accounting Software with QuickBaseNeat business, thanks for sharing. We are the same, nothing "out-of-the-box" works for us, that is why we LOVE QuickBase. Here are some constructioin accounting software we are reviewing. FOUNDATION - On Site or Cloud Based https://www.foundationsoft. com/construction-accounting- software/quickbooks-peachtree- users/ XERO- INTEGRATES WITH QUICKBASE AND A BUNCH OF OTHER APPS https://www.xero.com/us/why- xero/your-business/ construction/ SAGE 100 https://www.sage.com/en-ca/ products/sage-100-contractor/ SAGE 300 https://www.sage.com/en-ca/ products/sage-300/ PROCORE https://www.procore.com/en-ca VIEWPOINTACCOUNTINGFOR CONSTRUCTION https://www.viewpoint.com/en- ca/solutions/accounting-for- construction VIEWPOINT PROCONTRACTOR (ACCOUNTING, PM AND ESTIMATING) https://www.viewpoint.com/en- ca/products/procontractor COMPUTEREASEACCOUNTING https://www.construction- software.com/construction- accounting/ JONAS CONSTRUCTION PREMIER https://www.jonasconstruction. com/features/construction- accounting-software/ JOBPOWER https://www.jobpow.com/ ECLIPSE https://www.explorer-software. com/eclipse-software/ financials/ ACCOUNTINGEDGE https://accountedge.com/ INTERAC Construction http://www.intersoftsystems. com/interac-for-construction. html ------------------------------ GH GH ------------------------------ Re: Accounting Software with QuickBaseThanks for sharing Ivan, what industry are you in? ------------------------------ GH GH ------------------------------ Re: Possible Side Effects from Delete UserDoes anything happens to records that are owned by the deleted user? ------------------------------ GH GH ------------------------------ Accounting Software with QuickBaseHello Quickbasians, I am a home builder in Canada and we have been using QuickBooks Desktop for years but have out grown it. I wanted to see what other accounting software people use/recommend and how they integrate into QuickBase. Would be great to hear from QSP's on the different accounting software they are integrated into QBase for their customers. NOTE: We are a multi-company organization and Quickbooks Online does not do multi-company, so this is not an option for us. Thanks team! ------------------------------ GH GH ------------------------------ Snapshot Field From Same TableLooking for a way to create a snapshot field on a field in the same table. Example: I add a sale and a field generates a fee (using a formula field). This fee may change if the total sale amount changes. But if I make a change to the fees formula, I want the old value to stay. So update the snapshot field if the sale price changes but keep it the same if the formula values are changed. ------------------------------ GH GH ------------------------------Re: Using the Quickbase PHP SDK for displaying data on the webthe SDK uses simple XML so you just need to know how to make a php call and work with the response. let's say you have a do_query call let's say field 3 is the Name of a company. Assuming there is only one record. $result = $qbc->do_query($query,'','','','3.4.5.6'); $name = $result->table->records->record->f[0] //Because fid 3 is the first in call above. echo $name; make senseRe: Update Records based on Dates in the RecordSorry, what I meant was is there to automate this based on a date field. Like a CRON job, if a the date in a field equals today, do something to the record.