LyndaSchutter1
Qrew Trainee
Joined 5 years ago
User Profile
User Widgets
Contributions
Sharing a form with entire organization
I have created a request form that I would like anyone in our organization to complete and save. I was under the impression that each person in the organization did NOT need quickbase app itself, just the link to complete the form. is that accurate? Any guidance would be helpful ------------------------------ Lynda Schutter ------------------------------New Forms - links
I tried inserting a link to a rich text on the new form and would like to attach a couple document links like the "Include Links" shown in the example. I have been able to insert the URL, but not been able to display a particular text instead of the url address. Is this a glitch with the new form or am I missing a step somehwere? ------------------------------ Lynda Schutter ------------------------------Timeline troubleshooting
I have created a timeline for my project list and placed it on a tab at the bottom of a dashboard. When I filter by Project lead, the timeline estimated start date shows 2 months later than the estimated start date listed. When I click on the bar, the bar moves and displays the correct day. Any ideas on issue? ------------------------------ Lynda Schutter ------------------------------Re: Creating a Discussion board
When I reply to a post in my new discussion board, the reply does not connect to the original question. I'm thinking it has something to do with the thread ID On the discussion board in quickbase builder, the thread ID number auto populates. I mirrored the formulas into my build, but still cannot get the id to populate. I have a URL formula for the reply as URLRoot() & "db/" & Dbid() & "?act=API_GenAddRecordForm&_fid_32=" & If(Length(ToText([Thread ID])) = 0, ToText([Record ID#]), ToText([Thread ID])) & "&_fid_6=" & URLEncode([Subject]) and the Thread url is URLRoot() & "db/" & Dbid() & "?act=s&query=" & If(Length(ToText([Thread ID])) > 0, "{'32'.EX.'" & ToText([Thread ID]) & "'}OR{'3'.EX.'" & ToText([Thread ID]) & "'}", "{'32'.EX.'" & ToText([Record ID#]) & "'}OR{'3'.EX.'" & ToText([Record ID#]) & "'}") & "&clist=6.10.12.30.4&slist=6.3&opts=sortorder-A.groupby-V.nos." ------------------------------ Lynda Schutter ------------------------------Re: Formula to calculate weekdays
Thank you so much for the quick response! in the first formula I get an error message "expecting duration but found number" My Orientation Complete and Effective Date are both date field types and my field to display the numbers are Duration-Formula. Should those be something else? ------------------------------ Lynda Schutter ------------------------------Formula to calculate weekdays
I am trying to figure out total "Days on Orientation and "Days Overdue". My current formulas are able to give me the total days, and not business days. What do I need to add to the below formula to count only business days? Total days on orientation: If([Process Status]="Completed",([Orientation Completed]-[Effective Date]),Today()-[Effective Date]) Total Days Overdue: Today()-[OVT Due Date] ------------------------------ Lynda Schutter ------------------------------
