# Best Method for Updating a Collection/Table

**URL:** <https://community.weweb.io/t/best-method-for-updating-a-collection-table/10494>\
**Category:** How do I?\
**Tags:** workflows, xano\
**Created:** [August 27, 2024, 10:27pm UTC](https://community.weweb.io/t/best-method-for-updating-a-collection-table/10494 "2024-08-27T22:27:44Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ctown](https://avatars.discourse-cdn.com/v4/letter/c/e19adc/32.png) [@ctown](https://community.weweb.io/u/ctown)\
**Post date:** [August 27, 2024, 10:27pm UTC](https://community.weweb.io/t/best-method-for-updating-a-collection-table/10494/1 "2024-08-27T22:27:44Z")

</div>

I have also posted this to the Xano community because it may be more fitting there but this community always tends to be more involved so I thought I’d post here as well.

I’m not certain I’m going to word this in a way that makes sense but I’ll give it my best shot.

I am using Weweb as a front-end with Xano as my back-end. I have a table/collection that for the sake of simplicity and for this example lets say it has 6 different fields.  
ID  
title  
start date  
end date  
user  
notes

In this particular case the initial creation of a new record may only include a start date and title and of course the ID which will auto generate. Over a period of time the other fields will be populated but most likely at separate times.

I’m trying to determine what the best method is for update. My concern would be having one API call that updates the fields if all are not populated. So in other words if the title is set I wouldn’t want to over write it with a null value. Is it better to have an end point for each field and just call them as needed? Is the patch end point the ideal solution? I want this to be efficient as possible and I feel that the multiple single API calls would be more of a burden than necessary if there’s a more efficient way I’d love to hear it. Also, if I’m thinking about this all wrong please let me know.

Thanks in advance.

---

<div class="post-metadata">

**Author:** ![rice](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/rice/32/11161_2.png) [@rice](https://community.weweb.io/u/rice)\
**Post date:** [October 17, 2024, 10:31am UTC](https://community.weweb.io/t/best-method-for-updating-a-collection-table/10494/2 "2024-10-17T10:31:04Z")

</div>

Hi,

Just wanted to chime in here. I keep running into a similar issue with trying to find the most efficient solution for whatever it is I’m trying to accomplish.

My best advice is - don’t worry about efficiency right now and just focus on getting a working product. Once you have a working product, then you can go back and see if there is a more efficient solution. You may not even need to.