Skip to main content
Question

File present at URL?

  • August 17, 2020
  • 0 replies
  • 30 views
Hi

Is there anyway within a formula field to check if a file is present at a URL (a file uploaded to Amazon S3)?

In other words (in quasi code / plain english)...

If a file is present (or maybe we use if file size is >0) at a specified URL, return 'true', otherwise return 'false'.

Thanks

David

------------------------------
dmlaycock2000 dmlaycock2000
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+17
  • EvanMartinez
  • Community Moderator
  • August 17, 2020
Hi David,

Within a standard formula field that wouldn't be possible, formula fields look into QB and data contained on the same table within an application to make decisions on data. It may be possible to build an API call or Pipeline that can kick off to query your outside system and bounce back a response to update a Quick Base table but that would require a bit more complicated a build then a formula fix. So with the URL you would provide to it you are looking to have a system go out to that URL and check a field in a form on that service to see if a file attachment is present and then if not write back into QB an update on the record to say yes or no?

------------------------------
Evan Martinez
Community Marketing Manager
Quick Base
------------------------------
Terms & ConditionsAccessibility statement