ContributionsMost RecentMost LikesSolutionsChange status field after review time expired Hi all, I have table as below Text field: Request Multiple choice field:approved (no and yes) Date/time field: approved date (dynamic form > when the record is save and approved is equal to yes, change approved date to current date time Multiple choice field: Review status (expired review, successfully reviewed) When the approve field is approved and approved date change to current date/timefor example 27 June 2020 07:00 AM, i want to setup 24 hours expiration for for review, so after 24 hours the status field is not changing, the review status will be expired status. Also if it’s possible to setup reminder for example 6 hours before expired? Many thanks ------------------------------ Syaeful Bahri ------------------------------Re: Copy rich text formula (url) to another tableHi Mark, Thank you for your response, it's lead me to another trial and error. Apparently, I found your old discussion and adjust the formula. Rather than rich text formula, I'm changing it to formula URL URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e138/v0'>" & [referee checking] Then I create URL field on destination table and using automation with some certain conditions to copy the field record from original table to destination table (url field) It's good to go through old discussion and found some interesting discussion that can be the answer Kind regards ------------------------------ Syaeful Bahri ------------------------------ Re: Copy rich text formula (url) to another tableHi Mark, thank you for your answer How about to have the link to another table?, it is possible to achieve this with the formula? Thanks Mark ------------------------------ Syaeful Bahri ------------------------------ Copy rich text formula (url) to another tableHi all, on my referee checking table, I have formula rich-text field that links to the attachment field "<a href='"& URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e90/v0' target='_blank' >" & [Referee checking form] & "</a>" I need to include this field to another table, what is the best practice to achieve this?. Can you please give step by step instruction for the solution? Many thanks ------------------------------ Syaeful Bahri ------------------------------ Re: How To Copy File Attachments Between Tables Without Download?Hi Mark, Can you please tell me step by step to achieve your solution? Many thanks ------------------------------ Syaeful Bahri ------------------------------ New field based on date durationHi All, I have Table event consists of Event name: Quickbase training (text field) Start date: 1 April 2020 (date field) End date: 3 April 2020 (date field) Duration (days): 3 (Formula - Numeric) I want to create a new table that consists ofattendees status dynamically based on the duration field above Something like this if possible Day 1 Status: Online Day 2 Status: Offline Day 3 Status: Online If the Duration (days): 5, there will be Day 1 Status: Online Day 2 Status: Offline Day 3 Status: Online Day 4 Status: Online Day 5 Status: Online and so on according to how many days for durations Many thanks ------------------------------ Syaeful Bahri ------------------------------ Summary data from two tableHi All, I have two tables. Below are the details of each table. Table 1 Table 2 I have imported the data for each table, the data is from the CSV file. Table 3 will have a summary from Table 1 and Table 2 like this Can you please give me direction how to achieve this? Many thanks ------------------------------ Syaeful Bahri ------------------------------ Re: Quickbase Attachment from Egnyte File SharingThanks for pointing me out about this Erich. I'm trying your solution now. Kind regards, ------------------------------ Syaeful Bahri ------------------------------ Quickbase Attachment from Egnyte File SharingHi All, Have everyone implement a solution to integrate QuickBase with Egnyte?. There is a field on Quickbase where users attach files. The file already saved on Egnyte. Basically we use Egnyte as our file storage. When we need to attach documents in Quickbase rather than browse our computer, we browse Egnyte directly to choose the file to attach. I have tried Zapier with this scheme This scheme makes us choose the file from our computer and attached it to the specific folder we setup. Is not browse Egnyte directly. Many thank ------------------------------ Syaeful Bahri ------------------------------ SolvedRe: Automatic Current Date Tracking Based on Status Field ChoiceThanks Mark, really appreciated ------------------------------ Syaeful Bahri ------------------------------