I have managed to successfully add records via API using pipedream custom code step. This really is very good. Well done softr, youâre delivering the full house here.
@Acefast Care to elaborate?
Where have you found the API documentation for softr?
The public API for softr DB is available.
You have to use fieldIDs instead of names when creating/updating at the moment so you have to do GET to find them out in ortder to create your payloads. So far so good.
How have I missed thisâŚ
Thanks!
+1 on this. Havenât heard any announcements on this. But great itâs available
Would it be possible to import data into a CURRENT table in the softr Databases either by CSV or paste? For alot of people looking to switch from AT to softr DB this will be essential
@Jjenglert Thanks for this update as really helps seeing the direction. Can you please help clarify for me;
Re Point 4:
Will the one click import allow import for all the existing Airtable scripts and existing automations?
Re Point 6:
Will softr database not handle scripts as we currently use this for updating/creating tens of thousands of records every day (mostly updating).
Additional Qs:
-
One of Airtables biggest weakness is PDF generation requiring APIs to other 3rd party PDF generators. I would think this would be number 1 priority feature for value add? When would Softr have that as personally we couldnt justify moving backend to re map all our 3rd party integrations unless Softr are better than Airtable in terms of functionality (not just performance speed).
-
When will AI fields be available as we use them all the time when a new record is created, triggering AI fields, analysing pdfs etc. And how will they be better than Airtable?
-
We use Airtable to generate QR codes for packets (bundled products) that are receipted into stock. Our users then click button to print these off and staple onto packet.
Users can these scan these codes via their mobile.
Can you let me know when this will work in Softr otherwise we couldnt move away from Airtable and I assume many other inventory users are in the same position? -
For actions on creating/uploading Products, we use an airtable form where users select products based on images as Softrs conditinal forms dont allow images to be shown against the record. When will Softr allow this as otherwise we are unable to user Softr for this? See below link to feature request.
- In Softr front end we manually have to create filters as Softr doesnt handle look up fields. When will Softr allow for this? See below link to feature request.
- Softr front end doesnt allow colour palletes on tags for Airtable single select fields generated from formulas. When will Softr allow for this? And will Sofrr databases have single select conversion options like Airtable does? See below
Thanks!
A lot here @FPX , let me do my best to answer you:
Re. one click import - it will not import scripts or automations as SD doesnât have either. It will import all relations, loops, rollups, etc. And once Softr workflows launches, you can rebuild those AT automations there, or use another platform like Zapier, n8n, etc.
Re. scripts - not in the foreseeable future. Youâll be able to run code in workflows and other options, but not scripts at the moment.
Re. pdf integration - also not in our near term future. If you need this, youâd need to use external platforms to handle it.
Re. AI Fields - weâre hoping for a couple of months from now.
Re. conditional forms - I donât see it on our roadmap at the moment, but I encourage you to add it via a feature request.
Re. Softr has lookup fields in SD, but not in interfaces. No timeline for adding to interfaces yet.
Re. sync colors for tags, something we plan to allow but canât give you a timeframe there.
This here is a good feature list
But for Now, I am just praying here, hoping to get some basic functionalities added.
Like - Rick Text option in Long Text Field in SD.
@Jjenglert - Any insights on this?
Question on the API. We are able to add via API using the fieldIDs which can be found using a GET. However, this becomes an issue when we are using the single select as this also has IDs so lets say you have 100 options on the single select you would need to obtain all ids for each dropdown option to use them via API. Itâs either that or do a query for them each time and thatâs alot of calls and such when just using lables/field names would solve it.
Any idea if/when this might be actioned?
Hi @Acefast you can send values too and we will match or create new options.
Id, Label, {ID, Label} all work for various combinations.
This is true for linked records too. Hope this helps!
@AmeerKhatri6167 SD currently supports rich text options as we donât strip any of the formatting when saved in the DB.
However, our interface doesnât render it yet, something that weâre working on.
One question⌠how about rendering of functions? Currently you can write a function in AT and boost it out to see how it looks so if youâre creating XML itâs handy. Any plans for this?
@Jjenglert , that sounds great. so it will create a new linked record if one doesnât exist with that name? Thatâs something AT doesnât do.
Yes, that is true. If you are able to test and confirm on your side, thatâd be great too!