Posting Non-Existing Data
How can I set up this such that I only create a new row if it doesn't already exist:
Answers
-
Hey there,
You are able to us the "Add or Edit record" function instead. This allows you to set an identifier to lookup the record by, if the record is found it will edit it. If not it will create a new record.
Alternatively if you don't want to edit a record, you are able to first do a get record function, you will search by a unique identifier, and then use a condition. If the get record step = null then add a new record, else do nothing. -
i think most simple and effective way in this case would be run id check like so and use precondition
upd:
that would work to check existence of a unique value in field with true\false statement.
if u need to run existence check with more complex parameters - use query all records with whatever complex query you need - and then change its output type to "exists" - that works perfect for me in every complex scenario so far -
Categories
- All Categories
- 53 ? Announcements
- 47 ? Releases
- 37 ? Welcome
- 983 ? Help! I'm a Noob
- 125 ? No-Code Front-Ends
- 633 ? Working with APIs
- 439 ? Transforming data
- 126 ? Connect Xano to ...
- 50 ?? Find an Expert
- 348 ❓Other questions
- 35 ? Security
- 22 ✂️ Snippets
- 19 ? Showcase
- 7 ?️ Xano Chatter
- 62 ? Video Tutorials
- 171 ? Request a feature
- 229 ? Report a Bug
- 19 ? Templates & Extensions
- 7 ? Feedback