Development &amp; APIs

Custom Block Scroll

The custom block seems to retain the scroll position when moving between components which get replaced based on State. Is there any way to always load page with scrolled at top of Block UI?

101

F_terstalNew Participant

API update records doesn't work in postman.. created records does work and get records work to

HI, I read the document : https://airtable.com/appEYx9XUfEttr3Nr/api/docs#curl/table:table%201:update I just copy and past the code… and i get errors… but getting records or creating records it is working… I put the api_key as a parameter and in headers both doesn’t work for updating the records… In the header is put Content-Type: application/json https://api.airtable.com/v0/appEYx9XUfEttr3Nr/Table%201 { "records": [ { "id": "recwpwzgzp7pTHfMb", "fields": { "Name": "test", "Notes": "test" } }, { "id": "recjKjPPQqaXh60MH", "fields": { "Name": "test2", "Notes": "test2" } } ] } { “error”: {

461

WidgeticKnown Participant

Too many re-renders

Hi all! I’m trying to read from two tables using useRecords which have a limited number of fields to create a stateful content variable which I have to pass on to the next react Component. Here’s my code const { translator, compId } = props; // Block viewport const viewport = useViewport(); const [editorVisible, setEditorVisible] = useState(false); const [content, setContent] = useState(demoContent[0].content); // Block settings button useSettingsButton(function () { if (viewport.isFullscreen) { setEditorVisible(!editorVisible); } else { viewport.enterFullscreenIfPossible(); setEditorVisible(true); } }); // read the current tables and translate the content to // 'content' object const contentTable = base.getTableByName("Content"); const detailsTable = base.getTableByName("Details"); const contents = useRecords(contentTable); const details = useRecords(detailsTable); const relevantDetail =

722

Charanjit_KaurNew Participant

Attaching screenshot via api

Hi, I captured a screenshot via code and it returns me data uri of image. I need to upload that on airtable but when i tried manually through aortable link url option in attachment field, getting this error “Error fetching URL metadata.” I need to confirm that i will accept data uri or not. How i will upload screenshot through code if its not accepting data uri of image. Thanks in anticipation

191

Savalas_ColbertNew Participant

Naming our Apps

Is it ok to use the Air name in the naming of our app?

322

Rob_RoseNew Participant

Pro account coupon for Blocks contest?

I wanted to enter the Airtable Blocks contest but I don’t have a Airtable pro account for testing my application. Is it possible to get a coupon code for a testing workspace so I don’t need to pay? Thanks, Rob

283

Pjero_KusijanovKnown Participant

Integromat Search module formula with date lookup field

Hello there, Please help me out with Integromat Search module. I used this formula in Integromat Search module to send email 2 days after check out. Check-out is lookup field. IF(AND({Rev}!="", { :x: }=BLANK(), DATETIME_DIFF(TODAY(),{Check-out},‘days’)=2),“1”,“0”) The formula seams to work in airtable, but the search module does not always return correct result. for ex. same email was sent 2 days in a row, which should not be possible because 2 days difference can be only on one date :confused: Please advise, Thank you

442

Leslie_MillerKnown Participant

Help pulling info to create a HTML

I would like to fill a field that results in this HTML text The items in italics are Airtable fields within that Airtable table <!DOCTYPE html> <html> <body> <h4 style="text-align:center;">*Workshop Title* </h4> <p style="text-align:center;">*text Date Range Friendly* <br>*Text Bottomline* <br>*Medium* </body> </p> </body> </html>

1302

Chris_GuthrieInspiring

How to get record ID of filtered record [solved]

Hi, I think I’ve figured out how to retrieve a unique record in my table using the following filter, but how can I get the ID of resulting query? let filteredRecords = query.records.filter(record => { let name = record.getCellValue('Order/Shipment ID'); return name !== null && name === range }); I’ve tried the following but am getting an error let filteredRecordsResult = filteredRecords.records[0]; output.text(filteredRecordsResult.id); Error: TypeError: Cannot read property ‘0’ of undefined

1195

Savalas_ColbertNew Participant

Is it ok to integrate the block inside of a another app?

Hi, is it ok to integrate the block functionality inside another app for displaying purposes?

RnJInspiring

IOS app keeps crashing. Any performance updates coming?

I have a fairly large base (approx. - 20k records, 20 tables, 300 fields, hundreds of views, etc.) and I am no longer able to open the IOS Airtable app (keeps crashing). Also tried to open via desktop mode on iPhone10 browser but crashes too. I must currently use a desktop/laptop to access my base. My temporary workaround was going to be use a shared view/snapshot of the information that I always need when away from desktop/laptop (view only/no editing) which would limit the records down to the view of a few thousand records. That worked ok, however I can’t filter & sort the information using the mobile website. Tried switching to desktop mode, which would have worked great, but I can’t scroll the base up/down & left/right. Any performance updates coming to IOS App? OR ability to filter/sort on mobile website views? OR ability to scroll on IOS with browser in desktop mode? Thanks.

552

Keith_ArmstrongNew Participant

Save Spreadsheet at end of day

Hey guys! Fairly new to scripting so bare with me. Wondering if it possible to export a spreadsheet at the end of the day using a script. This is for an inventory management system for a resort, and we would like to export the logs of the spreadsheet at the end of everyday via an IPAD. Ideally a staff member could press the script, and it would automatically export and save somewhere on the cloud. Any help with this would be greatly appreacied.

554

WidgeticKnown Participant

Cannot create table

Hi all! I’m trying to create a new table using base.unstable_createTableAsync following the example in the guide. This is the code I’m using - const fields = [{ name: "MyField", field: FieldType.SINGLE_LINE_TEXT }]; if (base.unstable_hasPermissionToCreateTable("MyTable", fields)) { await base.unstable_createTableAsync("MyTable", fields); // and create records } But I keep getting the error Uncaught (in promise) Error: Can't create table: invalid field config for field 'MyField'. Creating or updating options for undefined fields is not supported at this time. at Mutations._assertMutationIsValid (bundle.js:formatted:7299) at Mutations.applyMutationAsync$ (bundle.js:formatted:6813) at tryCatch (bundle.js:formatted:94903) at Generator.invoke [as _invoke] (bundle.js:formatted:95131) at Generator.prototype.<computed> [as next] (bundle.js:formatted:94956) at tryCatch (bundle.js:formatted

512

Stephan_KardosNew Participant

Custom Blocks Contest: Designer with idea looking for developer

Hey everyone, my name is Stephan, I am a designer and have an idea for a quite useful block. I believe it’s simple but powerful and I have the high-level concept together. It’s for the Education category but easily can be used in professional and everyday life. I would need a developer to create a prototype with me. I would take care of UX and UI plus tables logics. Skills I’d need: react, js, cloud services, a bit of frontend. If you feel like you can participate in a sprint with me, do let me know. Stephan

Mike_YamatoNew Participant

Scripting, sorts displays correctly with output.table() but within the grid view of the UI

I’m trying to sort my records alphabetically and it logs perfectly with output.table() as you see below (first screenshot). But when I close the Scripting block it’s not reflected in Grid view (2nd screenshot). What additional step am I missing? Sorted correctly Not sorted

292

Sidney_MLNew Participant

Record ID showing on Appsheet instead of value

I am using Airtable as a data source for an app on AppSheet. Everything seems to work well except for values from linked tables. As shown in the image below, when a value is coming from a linked table, it is showing the record ID instead of the actual value. How can I fix this?

932

MixableNew Participant

Date format hints and question on localized date formats for users

I noticed the date value provided is structured as M/D/YYYY. Is this consistent across all users? Or does this change depending on regions? ie. D/M/YYYY for EMEA Airtable users, M/D/YYYY for US Airtable users, etc. This might be a new Feature Request, but it would be awesome if CellRenderer can provide an easy Field type toggle to generate more consistent “universal” dates. I would love to see something like YYYY-MM-DD being available.

572

Christian_RainwNew Participant

Attachment field not populating on Zapier

Hello everyone, I am trying to add the uploaded files to my base into a Zapier email. Not sure why its not working on this specific base. I have it working on another base of mine. Here are my links: [https://airtable.com/shr4OWctZTkg3CfVd](http://Airtable Base with Attachments)

181

Dima_LkhagvatogNew Participant

Custom Block Folder is Empty

We are trying to create a custom block. We follow all the instructions in the video, but we find that our folder is completely empty. How can we solve it? Thanks in advance.

161

Kamille_Parks11Brainy

No-Conflict Appointment Scheduler

Use Case: You have a table of stylists, therapists, technicians, etc. (“agents”) who perform any number of services, and customers are supposed to schedule an appointment with an agent to perform a service but only when that agent is available. While you think the No-Conflict Asset Reservations script is great, it doesn’t take into account your need to schedule an agent for more than one appointment per day. Solution: No-Conflict Appointment script by Kamille. An improvement upon my previous script, you can now schedule same-day appointments assuming those appointments don’t overlap. It allows users to select a service, pick a qualified agent/employee to perform that service, and then select upcoming dates and times which work for that agent. The script opts to use buttons as opposed to text box inputs to reduce human error in typing

1865

MixableNew Participant

Does expandRecord() function exist for new entry creation?

I’ve been using the expandRecord() function call to provide a quick way to update content in my Block interface, but I would LOVE to use that flow for new data entry as well. Is that possible? I’ve read through the documentation and example projects and I didn’t see this noted. And expandRecord() does currently require a record to be passed to it.

552

TuurInspiring

Blank problem - serious stuff

Is this on the radar? Using "!=blank()" is not returning the correct result Formulas :angry: Just got bitten by this one again. Is this on

663

Josh_CooperInspiring

Script to put current Date/Time into a Date/Time field with a button

So this is probably a dumb question, but I have hit a wall! How do you write into a Date/Time field with the current date in the locale timezone? I have tried the .toLocaleString() method and the console will output everything perfectly, but nothing shows up in the field. This is what I have. var rightNow = new Date(); var res = rightNow.toLocaleString(); table.updateRecordAsync(record,{ "Date/Time Submitted To Shipping": res }) Any help would be greatly appreciated! Update: I can get the Date/Time in a Date/Time field by using the .toISOString() method, but the time is 5 hours off.

2783

francisco_silv1Participating Frequently

Add record from released custom block

i have button to add record. before release , in development ,was able to add record from custom block succesfully with `table.createRecordAsync’ . when block is released does not add new record. block is started on terminal

827

Tommy_ChanParticipating Frequently

Example code for the wizard UI component?

Hi team, I’m working on an exciting block for the Devpost but that requires a user to prefill a few things (AWS key/access) and I see that in the Google Translate block, there is a nice Wizard set up page: Is there some sample code somewhere where we can see how the wizard works? It’s not listed as a component on Airtable Blocks SDK but the Design guide does seem to reference it Quip TIA!

742