Syndicate content

You can create a formula field of type text that has the following formula:

List("-",ToText(Year(ToDate([Date Created]))),Right("0" & ToText(Month(ToDate([Date Created]))),2),Right("0" & ToText(Day(ToDate([Date Created]))),2))

February 5th, 2009 - 6:02 PM

If the key field for your master table that contains the actual file attachment field is the built-in Record ID# field then you can put the following on your Exact Form:

~="<img src='/up/dbidofmastertable/a/r" + fid["11"] + "/e17'>"~

you'll need to replace "dbidofmastertable" with the dbid of the table that contains the pictures. To learn how to discover dbids please read:

February 5th, 2009 - 6:02 PM

QuickBase operations time out after a fixed number of seconds, so the file upload needs to complete before this time out. The two most common reasons why the uploads don't complete is because either of following two causes:

- The file is too large. This can often be remedied by compressing the file with a third party compression application.

February 5th, 2009 - 6:02 PM

There are issues in some Microsoft Internet Explorer and Microsoft Office configurations that can cause problems with downloads. We've seen the issue with all types of Microsoft Office documents and with PDF files. The issue can affect all QuickBase downloads including file attachments, exporting to a spreadsheet, and custom pages.

February 5th, 2009 - 6:02 PM

Just create a Formula URL field and use the following as its formula:

"javascript:if(confirm ('Are you sure you want to delete this record?')){location.assign('/db/" & Dbid() & "?act=API_DeleteRecord&rid=" & [Record ID#]& "&rdr=" & URLEncode(URLEncode(URLRoot() & "db/" & Dbid() & "?a=q&qid=7")) & "')}"

February 5th, 2009 - 6:02 PM

You can add a recurring record or tasks link field (which can be made to look like a button) by clicking on the link below.

February 5th, 2009 - 6:02 PM

In HTML, you can create input tags, set the type to "checkbox", and indicate the name using either the field ID or field name. If you don’t want your users seeing the field on your form, use the optional parameter "fform" to set the type to be "hidden".

February 5th, 2009 - 6:02 PM

© 2016 QuickBase, Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit