Mar 11, 2020 09:51 AM
How could I find out how many records there are in a table?
recordsMax = base('Table 1').size() Something like that, but it actually works.
Mar 11, 2020 10:41 AM
If you are looking for records in one table (not base) you will find the number if records in the bottom left corner. For the full Base you will find it in your account under workspace.
Mar 11, 2020 10:53 AM
He’s asking how to get this data through the API. But, it depends on which API - from a script block @ben_jones1?
Mar 11, 2020 11:10 AM
Mar 11, 2020 11:32 AM
Mar 11, 2020 11:35 AM
I am using Visual Studio Code.
Mar 11, 2020 11:52 AM
And where (exactly) are you planning to run this code you are writing in VS Code?
Mar 11, 2020 12:23 PM
In this file:
Mar 11, 2020 01:12 PM
As such, You must use the gyazo platform and whatever scripting features they allow to perform an HTTPS POST request to the Airtable API. To know the exact code to do this would require intimate knowledge of the gyazo platform. Once you are able to make a request into Airtable, you can iterate across the record set to count the number of records in a given table.
Since the gyazo platform supports a public REST API, a more appropriate approach may be to build your Airtable API code in a platform that you control and one in which Airtable’s SDK resources are available to make this easier.
I assume your goal is to pull images from Gyazo into Airtable or to pull images from Airtable for use in Gyazo. If this is correct, you probably need a NodeJS app or possibly a Google Cloud Platform app that can read from Gyazo and write to Airtable.
To be clear - all this is all simply speculation on my part because I don’t really know anything about your project or its objectives.
Mar 11, 2020 01:15 PM
Gyazo is a photo program, not a scripting system.
Mar 11, 2020 01:23 PM
Indeed it is. However, when asked where your script being developed in VS Code was going to be executed, you gave us a URL with the Gyazo.com domain. If the code is being executed on that platform, it is - by definition - a scripting platform.
If your plan is to actually execute the code someplace else, just need to know more about the design of this integration to be more helpful.
Mar 11, 2020 02:13 PM
I sent the gyazo link as I can’t upload photos to here, it just shows the directory of my file.