New Action: Add a Row to a table

Hi @Michael

I haven’t tried it yet. But I’ve planned to do a test app either this week or next week. Email me over the email you use for your Appsheet account and if I can get it working I’ll share it with you

Simon@1minManager.com

3 Likes

… Share with us on this thread??

Sure @Henry_Scott

1 Like

Is there a way to invoke this action but also go straight to an edit form of this new row of data? My scenario requires duplicating an existing row, but omitting an existing mandatory field and requiring the user to input a new value for that mandatory field. At the moment if I try to accomplish this with the new action, it’s trying to enforce the mandatory aspect of that field (So I can’t push a blank value of that column).

Instead of copy-and-edit, use LINKTOFORM() to create new with prepopulated column values.

2 Likes

Thanks Steve, wasn’t aware this would serve the purpose I was chasing. Just implemented then into my app, working a charm!

1 Like

Hi, for some reason the method 2 with enum list column doesn’t work in my app.

  • I have action in Table A where I’m triggering "execute an action on a set of rows” in Table B.

  • Action executed in Table B is the “Enum item” group action which includes the “Enum item1” to “Enum item5” actions that ultimately should create rows to Table C. Table B already has EnumListColumn that contains up to 5 items.

  • Each row in Table C should consist of [Key], [Column1] and INDEX([EnumListColumn],1…5), the same way your app creates as many rows as there are items in the enumlist column

I have the same criteria ISNOTBLANK(INDEX([EnumListColumn], i ) ) in “Only if this condition is true” for each “Enum item i” action. It creates the first row ok, but after that it just creates 4 empty rows with [Key] populated, no matter how many items is in enum, and also omits the static Column1 from the rows.

any idea why this happens?

Hi @Mikko_Palmu. Thank you for reaching out. There might be different reasons. Would you mind sharing the app to me as a Co Author? And also the Google Sheet.
wapplabor@gmail.com
You can also make a copy of the App and share the Copy. So I could look into it.

Hi @Fabian, I’ll make a copy of the app and try cleaning it a bit, translate the important table/column names to english and share it with you

Hi @Fabian

I added you as co-author and shared the Google sheet. I appreciate if you have time to check it!

Hi @Mikko_Palmu thank you for sharing your App.
I’ve checked it and I would say that it should work.
Therefore please send an E-Mail to support@appsheet.com and if you can, please add a short Video of the steps.
For me it looks like a bug.

How do I add a record to the same table without opening a form?

I recommend that you study this app:

2 Likes

Can you please indicate which page lists all the current resources relating to this feature including any videos and examples? Are good postings on this topic included there, e.g. how someone used it in a complex manner?
?

Sorry for the super late response, guess I missed this, was just randomly reading this thread again and saw this. @Jervz @praveen

Yes @Jervz that’s almost exactly what I planned to do as well! Using the linktoform() at the end for the parent record is a great way to circumvent the issue in the following post…
@praveen actually you can’t do that because of what I’ve brought up here: 'Data: add new row...' does not allow manually inputted key

2 Likes

Hii Praveen … But one issue is there that some columns are not available in the List those who contain Formulas or REF column

Has anyone had the issue of the data of an image not being copied over to the table?

All the data is being transferred as it should (text/datetime etc.) but not image columns.

Any ideas?

Hi @Chris_Jeal

Not entirely sure if this is the same. But I’ve found you can’t seem to use a text string in speech marks as an inital value for an image. It seems you have to create a formula to pull the same from somewhere else.

I have had this issue. I believe it is because the image is originally stored in a folder in your database (maybe google drive or dropbox), and when you add a row to another table, the image is still in the original google drive folder, and not in the new image storage folder, so it doesn’t show.

1 Like

Personally, I wish appsheet would put all images in 1 folder, to eliminate the hassle.