ContributionsMost RecentMost LikesSolutionsSend Weekly Reminder Email based on Criteria Hello, I would like to send a weekly reminder email 7 days after the record is created and would like it to keep sending until the Est. Start Date field is filled out. Can this been done? I would like it to only send the records that they are the record owner on. As an added bonus is there is a way to have the reminder email to start up again once it reaches the date in the Est. Start Date? Re: Force Lat/Long in Decimal Degrees The character length might work, it looks like they aren't putting spaces in so doesn't look like that would work. Thank you! Force Lat/Long in Decimal Degrees Hello, Right now we have a text field for lat/long and would like to force users to only being able to put lat/long in decimal degrees instead of degrees, min and seconds. We are also open to just some sort of message displaying if they put it in the wrong format. We would like the field to remain a text field and not a numeric one. Re: Need to transform data into a new field: State name = State abbreviation Mark, I did what you suggested and it did change the State field to the abbreviations but when the user uses the address search function the state field will not populate. Is there anyway around this? I am using the new form style, maybe that has something to do with it. 1 report - show whatever form ID that was used for that record Hello, We have created three different forms under 1 table. If someone creates a record using form 1 we would like to view that record in the form 1 format and if someone used form 3 then we would view that record in the form 3 format and so on. I know we can create different reports and select what form is used for each report but we would just like 1 report for all the different forms and QB to show whatever form format that was used for that record. Is that possible? Re: Add Save and Keep Working Button on form for a new record thank you so much, that worked perfectly. Original Message: Sent: 07-17-2023 14:23 From: Chayce Duncan Subject: Add Save and Keep Working Button on form for a new record There is a data-replaceRID component that you can place for new ones that QB will interpret and land you on the newly created record. This is an example of rich-text field using this: var text url = URLRoot() & "db/" & Dbid() & "?a=er&rid=%%rid%%"; var text link = "<a href='" & $url & "' data-replaceRid='true' style='font-size: 11pt;margin-left: 5px; margin-top: 0px; height: 33px; width: 160px; text-align:center;background-color:#13294d;color:white;background-image: linear-gradient(to bottom, #13294d 0%, #13294d 100%);' class='SaveBeforeNavigating Vibrant'>Save and Continue</a>"; $link The two components are rid=%%rid%% in the url and then the data-replaceRID param in the button itself. ------------------------------ Chayce Duncan ------------------------------ Original Message: Sent: 07-17-2023 14:19 From: Catie Bruno Subject: Add Save and Keep Working Button on form for a new record Hello, I would like to add a save and keep working button in the middle of my form. This would be used for new records that have yet to be saved before. Is that possible and how can I do it? I can get it to work for existing records but not new ones that haven't been saved yet. ------------------------------ Catie Bruno ------------------------------ Add Save and Keep Working Button on form for a new record Hello, I would like to add a save and keep working button in the middle of my form. This would be used for new records that have yet to be saved before. Is that possible and how can I do it? I can get it to work for existing records but not new ones that haven't been saved yet. SolvedRe: Using pipelines to create records-slow to create yes the pipeline records are being added to a different table than the one the user is currently in. I hope that answers your question. Original Message: Sent: 07-13-2023 13:15 From: Mark Shnier (Your Quickbase Coach) Subject: Using pipelines to create records-slow to create There's nothing we can really do to make the triggering of the pipeline quicker. However it appears to me that the pipeline steps Ron at a rate of about five per second. So if you're adding 23 records it could take five seconds for sure. Is the source of these child records from another table? For example are these standard tasks that get added to a project? ------------------------------ Mark Shnier (Your Quickbase Coach) mark.shnier@gmail.com ------------------------------ Original Message: Sent: 07-13-2023 13:12 From: Catie Bruno Subject: Using pipelines to create records-slow to create It's about 23 records ------------------------------ Catie Bruno Original Message: Sent: 07-13-2023 13:07 From: Mark Shnier (Your Quickbase Coach) Subject: Using pipelines to create records-slow to create Can you tell us how many records are being added as Child Records? ------------------------------ Mark Shnier (Your Quickbase Coach) mark.shnier@gmail.com Original Message: Sent: 07-13-2023 12:17 From: Catie Bruno Subject: Using pipelines to create records-slow to create I have table A that has embedded table B. Once a new record is added to table A then a pipeline is ran and adds new records to table B.However with using pipelines the user needs to save and keep working on the form for table A and then refresh a few times for all the pipeline records to show up. Is there a better way to do this? ------------------------------ Catie Bruno ------------------------------ Re: Using pipelines to create records-slow to create It's about 23 records Original Message: Sent: 07-13-2023 13:07 From: Mark Shnier (Your Quickbase Coach) Subject: Using pipelines to create records-slow to create Can you tell us how many records are being added as Child Records? ------------------------------ Mark Shnier (Your Quickbase Coach) mark.shnier@gmail.com ------------------------------ Original Message: Sent: 07-13-2023 12:17 From: Catie Bruno Subject: Using pipelines to create records-slow to create I have table A that has embedded table B. Once a new record is added to table A then a pipeline is ran and adds new records to table B.However with using pipelines the user needs to save and keep working on the form for table A and then refresh a few times for all the pipeline records to show up. Is there a better way to do this? ------------------------------ Catie Bruno ------------------------------ Using pipelines to create records-slow to create I have table A that has embedded table B. Once a new record is added to table A then a pipeline is ran and adds new records to table B. However with using pipelines the user needs to save and keep working on the form for table A and then refresh a few times for all the pipeline records to show up. Is there a better way to do this?