ContributionsMost RecentMost LikesSolutionsRe: How do I direct the data coming in from a connected table to populate a related field on another?One option is to make the relationship in the new app a formula reference field. Then just reference the value that is coming from the sync table to drive the relationship. This is assuming both table 1 & 2 are mirrors of the original. If not, you might have to look at the key fields in the corresponding tables.Re: Change font size (bold) for button on a form?Two things you can try. (1) use a large bootstrap button, rather than the formula url button. https://getbootstrap.com/docs/4.0/components/buttons/ and (2) Remove the native save button at the bottom of the form by Editing the form > going to the Properties tab > uncheck the bock to show save and close at end of form.Re: How to build table heading values as related table values in dynamically?Not sure I follow the question.....Re: RE: New update May 2018Yeah, this was happening last week when we had early access. It saves fine, and runs fine, but if you ever open the report settings, it will change the values. So a re-save will now have bad filters.Re: Dynamic Form Rule to Display MessageBe aware that if you have multiple 'when the record is saved' form rules, they might be conflicting. As far as the formulas not calculating right away, this could also be a result of too many form rules, or complicated formulas. Sometimes I see this when a browser is running slow because of too many formulas and/or too many other processes (tabs) running. Re: Refresh time before editing record with current time using the now() method.You either have to force them to refresh the page manually prior, or use a code page to 'get' the time and then write the record.Re: Calculate Weekend Hours in a duration of Date/Time FieldI just did this one for an internal project. It shows the number of weekdays from the start to closure and a running total if its not closed yet. var datetime Start=[Approved On]; var datetime End=If(IsNull([Completed / Closed On]), Now(), [Completed / Closed On]); var date SDate=ToDate($Start); var date EDate=ToDate($End); var number NumberOfDays=WeekdaySub($EDate, $SDate); Days($NumberOfDays)Re: Calculate Weekend Hours in a duration of Date/Time FieldThis might be better: WeekdaySub(Date d2, Date d1) Description:Returns the number of weekdays in the interval starting with d1 and ending on the day before d2 (same as subtracting Dates, but the result is the number of weekdays instead of a Duration). It is the inverse of WeekdayAdd. Example:WeekdaySub([Finish], [Start]) returns the number of weekdays between the dates in the Start and Finish fields. WeekdaySub(ToDate("6/24/2003"), ToDate("6/20/2003") ) returns 2Re: Calculate Weekend Hours in a duration of Date/Time FieldTry something like this (this will handle if its submitted ON the weekend. (starting point, I'll have to come back to deduct the weekend time if its submitted on a Monday kind of thing) var date SubDateOnly=ToDate([Date/Time Submitted]); //convert date/time to date var datetime NewSubmitted=ToTimeStamp(ToWeekdayP($SubDateOnly), ToTimeOfDay("11:59 pm")); //create a friday night at midnight timestamp var datetime AdjustedSubmitted=If(IsWeekday($SubDateOnly), [Date/Time Submitted]), $NewSubmitted); //If its a weekday, use the regular timestamp, otherwise use the friday night time. $AdjustSubmitted-[Date Created] //put it all together If your submittals are never greater than a week, then you could add some conditional logic to evaluate the start and end, and if the total is greater than x number (i.e. it includes a weekend time) subtract that 48 hours.Re: Record IDNot sure your use case, but a simple solution is to add it to reports, and then sort from large to small.