Search the Community

Hey! Is there any way to automatically and instantly insert new view's records into a separated table?

HI All, I'm looking to create something that automatically deletes a record after a certain number of days. Essentially: If ITEM is marked as FOO, delete after XXXX days. Anyone know if it's possible to do this?

How can I change the color of the header for the record index?

I'm creating an event management system and I need to be able to have our administrators make copies of events (not recurring, just duplicate the record in the events table - with a new unique ID of course). Does anyone know of a way I can insert a copy button as a link in a Tabular datapage or a Single Record Update datapage? Thanks so much! Clint

What I need to do: I have a table with a large amount of data per record. When the user goes to make their daily task (a form that makes a new record) I need them to see the blank form that has yesterdays submission pre-populated in it. The user then merely has to make todays edits and save it. Parameters: 126 x 3 fields need to be brought over to the new daily form, 2 checkboxes and 1 255 Text field. Known Issues: there is a 32k limit on passing external parameters from one datapage to another. What I have tried: Made a Report Details page that can find yesterdays submission and load it all as HIDDEN, then set the fields I want to move to the next Datapage as OnExit Parameters. Current issue is I need to automate the UPDATE button on the report page so users don't have to hit it to continue to the actual submission form. Second issue is that if there is a LOT of entries in that particular record, it can exceed the 32k limit and then a lot of fields get dropped. I would appreciate any ideas on a better method or how to fix the issues.... Steve Fraden

Hi to everybody. I have a problem. I need a table, and relative DataPage insert data than can insert data of more than one customer. In just one data Page i need to accept customer1 and customer2 data (name, surname, address, email, phone ecc) Now the problem is that i need to have the 2 customers, NOT in a table with unic horizontal line, but listed, with new id but with the same booking number, for a new record in the table. I think i need a new table but i can't be able to make triggers to copy data in a new table and records automatically (if that is the right way). (Ex. of the table/dataPage i have) ID_ booking | booking_number | n_of_ customer | Customer1_name | customer1_surname | customer2_name | customer2_surname| 1 56789 2 John Doe Mary Harris 2 56790 1 Micheal Lewis 3 56791 2 David Clarke Rose Smith (ex. of what i need) 1 56789 2 John Doe 2 56789 Mary Harris 3 56790 1 Micheal Lewis 4 56791 2 David Clarke 5 56791 Rose Smith How can i do? Thank you for your time in advance.

Hi, Forgive me if I've missed it in the documentation. Looking for a way to lock a record when another user is editing it. To prevent simultaneous updates to the same record. Thanks