Hi JJ. This is not an update of the year. This is an update of the century! With that said, this video scratches only the top of the surface. This topic is complicated and will probably require a series of videos to warm the users to this feature. More details on transformers. More details on POST/PATCH/DELETE methods that would insert/update/delete records. By the way the transformers concept is great. I wonder if something similar would be applicable to regular list item fields on dynamic blocks, so that we could finally re-format field content natively in Softr instead of doing it in the source (like Airtable formulas).
hello, is not clear to me how to pull all records from the database in the schema. It only shows 3 fields from the table metadata. but in the video is not clear how you get those.
Here is a copy of the transformer code that we used! return response.props.map(property => { return { id: property.zpid, address: property.address, estimate_price: property.price ? `$${property.price.toLocaleString()}` : property.zestimate ? `$${property.zestimate.toLocaleString()}` : "N/A", // Format price or zestimate as currency detail_url: `www.zillow.com${property.detailUrl}`, bedrooms: property.bedrooms, bathrooms: property.bathrooms, country: property.country, image_url: property.imgSrc }; });
Hi JJ. This is not an update of the year. This is an update of the century! With that said, this video scratches only the top of the surface. This topic is complicated and will probably require a series of videos to warm the users to this feature. More details on transformers. More details on POST/PATCH/DELETE methods that would insert/update/delete records. By the way the transformers concept is great. I wonder if something similar would be applicable to regular list item fields on dynamic blocks, so that we could finally re-format field content natively in Softr instead of doing it in the source (like Airtable formulas).
Responded to you on our forum 😃 So glad you love it though! We are working on an easier way to format data with our native data sources.
hello, is not clear to me how to pull all records from the database in the schema. It only shows 3 fields from the table metadata. but in the video is not clear how you get those.
Sorry - do you mind clarifying? "3 fields from the table meta data"?
Hello, how to use the transformer please? you copy paste script and you do not give us more information ^^
Here is a copy of the transformer code that we used!
return response.props.map(property => {
return {
id: property.zpid,
address: property.address,
estimate_price: property.price ? `$${property.price.toLocaleString()}` :
property.zestimate ? `$${property.zestimate.toLocaleString()}` : "N/A", // Format price or zestimate as currency
detail_url: `www.zillow.com${property.detailUrl}`,
bedrooms: property.bedrooms,
bathrooms: property.bathrooms,
country: property.country,
image_url: property.imgSrc
};
});