Skip to main content

Solved

7383 Topics
J
Jeremy_OglesbyInspiring
asked in Development & APIs
Setting a released Block back into dev state

How can I get a custom block that I have $ block release'd back into a development state? Would I need to start a new custom block, point it at the same repo as a remote, and develop there?

122
J
J
Jeremy_OglesbyInspiring
asked in Development & APIs
Close Settings Menu with Button

I’m trying to implement a settings menu in my custom block. I have the settings component properly showing, and the settings inside working as I want. The only missing piece that I can’t figure out is how to trigger closing the menu from a Button component’s onClick() function, rather than having to click the settings icon again to close the menu. I have this in my main block component: const [isShowingSettings, setIsShowingSettings] = useState(false); useSettingsButton(function() { setIsShowingSettings(!isShowingSettings); }); I tried calling the useSettingsButton() function inside the onClick() lambda, but got this error: Error: Invalid hook call. Hooks can only be called inside of the body of a function component. This could happen for one of the following reasons: 1. You might have mismatching versions of React and the renderer (such as React DOM) 2. You might be breaking the Rules of Hooks 3. You might have more than one copy of React in the same app See https://fb.me/react-i

74
J
B
BtbmlInspiring
asked in Formulas
Formula to Bullet Point a list

I have a multiline text field and I would like to use a formula field to take that multiline text and use the existing content but add a bullet point character in front of each new line. Is this possible? I’d like it to happen automatically without manually having to run a script Part 2 - If that works, I’d like to take the bulleted list and split it after 10 lines into a second field. Is this possible?

1647
B
N
Nathan_FeemsterParticipating Frequently
asked in Other Questions
Delete Fields in a Table

I’m trying out the new scripting block to try and make a utility for our base that will delete records based on a field and then delete the field itself. Is this possible? Use case: We use a table for semester data and then link it to all of the management tables. Each semester we make a new table and have to archive and update the linked field in all of the management tables. Semester data overlaps, so we can’t use the same table. We audit our fields and sometimes find that we no longer use the field and we want to archive all old records that used that field. Also, is it possible to export the filtered results to a CSV from a script? I would love to have this as part of the flow. I’m a beginner at code but, here is my attempt from looking at a bunch of examples: //Script to delete all records associated with a specific field and then delete the field. //6-3-2020 output.markdown('# Batch Delete Records and Field'); output.markdown('#### Before use, download CSV of sorted record

1306
kuovonne
R
Rvbanna_420New Participant
asked in Other Questions
Is there bandwidth limit in free plan?

hellow everyone! bandwidth is limited for free plan? or i get unlimited bandwidth with free plan?

165
R
G
Greg_MayeParticipating Frequently
asked in Formulas
I have an age formula that returns an "error" if no birthday is available. How do I remove the "error"

I have an age formula that returns an “error” if no birthday is available. How do I remove the “error”

105
J
R
Rajesh_NarayanaParticipating Frequently
asked in Formulas
Why does Formulae calculate Minus Zero?

I used a simple formula for column C (it is A-B), it shows up as -0 in one case and 0 for another? Why should zero have a negative sign? In my case although all 3 columns are setup to round to 2 digits, I am certain that there is no third decimal digit in either column A or B. Reason for asking is that it messes my colour codes where I’ve setup anything less than zero as red.

291
J
N
Noah_GlaserNew Participant
asked in Base Design
Finding entries in one table but not another: emulate an outer join?

I have two tables, one that is built in-house (say, INTERNAL) and one that is supplied externally (say, EXTERNAL). I don’t trust my external data source, so what I want to do is find all records present in INTERNAL and missing from EXTERNAL. If I were working in SQL, the query I would write would be something along the lines of: SELECT a.*, b.* from INTERNAL AS a LEFT JOIN EXTERNAL as b ON a.primary_key=b.primary_key where b.primary_key IS NULL I want to avoid using record linking; there are over 100 records to do this for, and my understanding of linked records is that they have to be done manually. Having to do this manually would defeat the entire purpose of using a database tool to speed up my workflow. Can the above analysis be done strictly within Airtable, or will I need to write an API script to emulate a JOIN?

346
kuovonne
L
Leah_HuelsingNew Participant
asked in Formulas
IF Less Than and Greater Than

IF(AND({Total Pages}<“50”,{Total Pages} >“43”,"$3.12"),IF(AND({Total Pages}<“12”,{Total Pages}>“1”,"$1.67")) What am I doing wrong? I’m trying to calculate postage by ranges…stating if Total pages is less than 50 and greater than 43, then $3.12, if total pages is less than 12 and greater than 1, then $1.67 and so on.

321
kuovonne
D
Deborah_ClarkNew Participant
asked in Formulas
Think I need a simple formula

I think this can be done, might just need to add a new field! On table ‘seed packets’, I have a manual number field to log how many seeds in the original packet. On table ‘sowing log’ it calulates how many seeds I have sown by N numbers in N numbers of stations (manually logged, auto answer (I didn’t set it up so language may be wrong). On the ‘seed packets’ table I appreciate I shall need to create a new field for the answer. I want it to take off the number of seeds sown from the original packet number I am familer with formulas in excel but not here so please, if someone could give me a simple starter I’d be most grateful; or correct me if I am heading down the wrong path

72
D
L
Leah_HuelsingNew Participant
asked in Formulas
IF Field = x, then = $5.00, OR IF Field=y, then = $1.00

Can someone help my brain wrap around this type of formula? I’m trying to get different amounts to populate based on what is selected in a different field. For example) Field 1 is State Trying to get Field 2 to calculate: if Field 1 is Missouri, then Field 2 should equal $2.00, OR If Field 1 is Illinois, then Field 2 should equal $1.00

73
M
L
Luna_LewisNew Participant
asked in Formulas
IF Multiple Select choice = x, then (amount*.25)

Hi, I’m very new to Airtable. I am crafting a budget base for freelance business. I have an Income table and I am trying to only calculate tax for untaxed income. I have a multiple choice selection with options “FREELANCE” and “PAYROLL” then I have a field for calculating the tax (amount*.25) I want to be able to only calculate tax for the records that are selected FREELANCE… IF multiple select = FREELANCE then (amount*.25) IF multiple select = PAYROLL then 0 I have no idea how to go about doing this, all my attempts have failed.

103
M
J
Jeremy_OglesbyInspiring
asked in Development & APIs
`$ block release` fails

Are we not supposed to be doing this yet, or did I do something wrong? schedule_conflicts| |master=> block release building copying package.json files installing node modules [npm] [npm] > core-js@3.6.4 postinstall /private/var/folders/lx/d2z19t052vx3m9jb9xpd71nm0000gn/T/airtableBlocks/build/1583468310281/transpiled/user/node_modules/core-js [npm] > node -e "try{require('./postinstall')}catch(e){}" [npm] [npm] added 77 packages from 133 contributors and audited 672 packages in 17.866s [npm] [npm] 2 packages are looking for funding [npm] run `npm fund` for details [npm] [npm] found 0 vulnerabilities [npm] [npm] npm WARN user No description [npm] npm WARN user No repository field. [npm] npm WARN user No license field. [npm] transpiling and building frontend bundle uploading build artifacts failed to upload build artifacts Error: Failed to upload /var/folders/lx/d2z19t052vx3m9jb9xpd71nm0000gn/T/airtableBlocks/build/1583468310281/build_artifacts/bundle.js at /Users/JM

88
J
J
Jeremy_OglesbyInspiring
asked in Development & APIs
Can't Access Example Blocks

I haven’t been able to access the example custom blocks for some time now. When I try to build one from the template, I get this: blocks|=> block init appFalshZ06hLqEPb/blkmXtdrOPFKUVPIW --template=https://github.com/Airtable/blocks-flowchart flowchart_example Using your existing API key from /Users/JMO/.config/.airtableblocksrc.json Initializing block using https://github.com/Airtable/blocks-flowchart template [git] Cloning into 'tmp'... [git] remote: Repository not found. [git] fatal: repository 'https://github.com/Airtable/blocks-flowchart/' not found ❌ Something failed! Cleaning up... Error: Could not get template https://github.com/Airtable/blocks-flowchart - please check you entered the name correctly And when I try to view the source code directly on github, I get this: My github profile, in case it’s a permissions issue: GitHub jmoglesby - Overview Software developer and test automation developer at BCBSAZ. - jmoglesby

52
B
A
Adam_Isler1New Participant
asked in Base Design
Using a lookup to another table to populate the choices in a single select field in the original table

I have a table, called ‘Industry,’ with 2 columns of Industry type codes. The first column has many repeat values in it, the second column are unique values, for example: Manufacturing Textile Mills Manufacturing Apparel Manufacturing Manufacturing Paper Manufacturing In another table I have a column called ‘Industry level 1’ which contains values from the first column of the table above (Industry). I’d like to add a 2nd column to it that’s a single select that looks up the values available for Manufacturing and displays them as the choices for the 2nd column. I’ve seen a range of questions like this asked but none answered that didn’t invoke JSON and code. Is there some way to do this natively in AirTable? Thanks!

212
A
D
David_WaltersKnown Participant
asked in Other Questions
Printing or emailing Blocks/Dashboards

Is it possible to either print out or email blocks/dashboards?

52
P
T
Tom_RInspiring
asked in Other Questions
2FA - can workspace owners see collaborators' 2FA settings?

Hi all, I am a workspace owner on the Pro account. We have 19 billable collaborators. Is there a way for myself as the owner to see who has/has not enabled 2FA on their account? Thanks, Tom.

112
T
R
Renata_LuciaParticipating Frequently
asked in Base Design
How can I hide completed tasks in table view?

I have created a table for our small architectural firm based on the “project tracker” template I found in Airtable. Once a task is completed, I need to be able to hide the task in the table view so that it is clear at a glance where there is work to do for each project (and have the option to unhide for when I need to review task history). I have worked out how to filter tasks by their status in the Task tab but seem to be unable to do so in the main table. When you are looking at the table, there’s no way to distinguish completed tasks from incompleted without opening up the row, and looking through all the tasks, which is causing me problems in meetings. Right now, the owners have me manually adding asterisks to the text of completed tasks AND I’m having to delete most completed tasks anyway, because they really pile up on the table view since I can’t hide them. You can see an example of what I’m saying in the “project tracker” template. In that template, under the “Design Projects”

645
R
H
Hunter_CasillasParticipating Frequently
asked in Formulas
Help With Switch Formula

SWITCH(PageID, "18479402361", "NKH", "8532248414", “WWP”, "8271670852", “LLS”, "342294162453301", “PP”, "27817332304", “AFSP”, "55701226138", “AHA”, "15687409793", “WWF”, "12692786774", “ALS, "184404096774", “LUPUS”, "105229062888132", “SSS”, "25372476424", “BFAS”, "12596759677", “RAICES”, "14084625156", “SGK”, “13793312555", “MAW”, "1562713090633117", “OUR”, "20876805343", “MOD”, "100438444321", “CCA”, "8492293163", “EDF”, "111541054636", “BTM”, "10331123781", “SO”, "371566686229476", “ADAA”, "342091725962792", “M22”, "8047221596", “STC”, "11791104453", “NRDC”, "81517275796", “UNICEF”, "512423278811960", “DS”, "122531741163825", “ALF”, "22902828717", “BB”, "332378771195", “CF”, "97646191545", “HA”, "44224524016", “AKF”, "332077995968", “LCRF”, "84618074710", “CCC”, "95155519857", “BLISS”, "24470472733", “TP”, "7271534916", “FFB”, "N/A") Here is my switch formula currently. I have genuinely been looking at this for 45 minutes now and I cannot seem to figure out why it is erroring

136
E
E
erlend_shNew Participant
asked in Other Questions
Is there a way to sort chronologically?

I see that I can sort by 1 -> 9 or A -> Z, but is there a way to sort chronologically?

10315
K
J
Jagow_SelbsthilNew Participant
asked in Base Design
Where can I download a PDF invoice with my address on it for the PRO plan?

Where do I find my invoice? Thank you

1182
P
D
Dina_AronsonNew Participant
asked in Other Questions
Preventing accidental record deletion

Hi! Five users are working with thousands of records in a table, and sometimes records accidentally get deleted. Is there any way to prevent record deletion per user, but still allow editing on the records? (except the primary field name)?

873
P
A
Andrew_StrotheiNew Participant
asked in Formulas
If Then Statement To A Single Select Option

I am wondering if I can take the column that’s titled “Client Lifetime Value” which is a numbers column… If the “Client Lifetime Value” is set at $37 I want it to print out “$37 Package Purchased” but if the value is $127 I want it to say “$127 Package Purchased”. I would like these to show up in a Single Select column at the end of it so that the options are colored and easily distinguished. We use the single select options to ensure that the filtering for the rest of the spreadsheet works correctly.

313
P
M
Melissa_HetheriNew Participant
asked in Other Questions
Quickly delete all data in a column?

This seems like a dumb question, but I can’t seem to find a quick way so I hope some of you can help? I have a base with many hundreds of records on it. The first column is all data that I need to get rid of. I can’t delete the column as it is the mandatory one. So I need a quick way to just clear the data in column 1. All I seem to be able to do is select and drag down to select multiple cells in the column to then be able to delete the data and this is taking a very long time due to the number of records in the table! Is there a more efficient way to do this?

892
M
C
Charissa_SantosNew Participant
asked in Base Design
New User getting started with User Research template

Hi, I’m a first-time Airtable user testing out the User Research template. Is it suggested to delete the sample data records and add your own records, or is there another place in Airtable where records get created?

222
C

Badge winners

Show all badges
Terms & Conditions