What is the Quick Base Hackathon? September 21 st saw the launch of the very first Quick Base Hackathon. With a prize pool of $250,000, it is the biggest competition we have ever had here at Quick Base and we want our citizen developers to ...
Mackenzie try this var text URL = URLRoot() & "db/" & Dbid () & "?act=API_EditRecord&rid=" & [Record ID#] & "&apptoken=APPTOKEN" & "&_fid_12=Yes"; "javascript:" & "$.get('" & $URL & "',function(){" & "location.reload(true);" " & "void(0);" ...
OK, right, you wanted month and I gave you years. I did not re-test this formula, but see if it works 'var date SD=[start date]; var date ED=[end date]; (Year($ED)-Year($SD)-1)*12 // start off with 12 times the number of fully completed years +If(Month($ED)>=Month($SD),12,0) ...
OK, maybe a new plan. How about setting up an Automation to fire when a child record Status is edited and a summary field lookup of the # of child records Approved is equal to a summary field lookup of the # of total child records. Or if you prefer, ...
Can you explain your use case? Are you adding a child record and want a Project # created automatically? Does the Child know the project # or is the Project # just the Record ID# of the Project. ------------------------------ Mark Shnier (YQC) Quick ...
You will need to change your Client ID# to be a text field after considering the implications of where it is used. You may want to to make a duplicate of that field and then change the type to text, fix the ones that need the leading zeros, and then ...
I think I need the bigger picture of what you are trying to do here. A formula field is not allowed to be the Key field of a table, if that is your question. ------------------------------ Mark Shnier (YQC) Quick Base Solution Provider Your Quick Base ...
Data Classification in Quick Base We are excited to introduce new Data Classification functionality that will allow you as a Quick Base administrator to define data classifications and apply these ...
If you encounter the below error message, it indicates that we’re experiencing heavy traffic to your Quick Base application from your IP address. Accordingly, we’ve placed a temporary block to avoid performance ...
New table report updates: applying changes, remembering your settings, and more With the Quick Base product release on October 18, 2020, we will be making the new table reports even more convenient. ...