An 'Add New Entry' interface idea

Hi Coda Community!

Just thought I’d share an idea I had for creating a section designed for users to add a new entry to a table. This may have been done before but I’m not sure!

In my case, I have a table called “Projects” and I wanted a quick way for users to add a new Project to the table. I decided to do this by creating a section with a Card view, but the view is filtered to only show rows created within the last 30 minutes. This means the card view will be empty on most visits, ready to click the ‘plus’ button, however if a user has just made a new row and wants to make a change, it will still be there for a while to quickly modify. By keeping it there for 30 minutes it also makes it clear to the user the row was actually created (as opposed to hiding it immediately).


The page ^


The formula ^

Created(thisRow)>(Now()-TimeValue(“00:30:00”)) && Created(thisRow)<(Now())

6 Likes

This is great @Josh_Unwin1! We’ve used a variant of this quite a bit internally, but not via the card view – will need to play around with this for sure.

We also have a bunch of mocks around what a proper form-entry experience could look like in Coda. What would you want it to feel like and how would you use it?

Thanks Evan!

That’s an interesting question - tricky one to answer.
I would think it would be dependant on the use case - it would be neat to have a type of form that can be sent to people to fill in (ala Google Forms) that functions like a webpage form. But it would also be good to have something within the Coda doc itself too. To be honest something like this card method works quite well.

3 Likes

So I tried putting in this formula to see if I could replicate. I’m getting an error? I know this is over a year old, so has something changed to let this not work anymore?

There may have been some changes to the TimeValue() formula.

This might work instead:

Now()-Minutes(30)

Hmmm, still not working:

Created(thisRow)>(Now()-(Now()-Minutes(30))) && Created(thisRow)<(Now())

I’m trying to basically have a place show up where they can enter the new words for flashcards in a form like view. Is this still a good way to do this? Or could someone think of a different way?

This was working for me on a test table. Can you give it a try?

Created(thisRow) > Now()-Minutes(30) AND Created(thisRow) < Now()

1 Like

Yep, that works! Thanks @BenLee