AJCampani
Qrew Cadet
Joined 7 years ago
User Profile
User Widgets
Contributions
Is there a way to populate the multiple choice selections in a text field with input from user?
Hello all, I'm trying to create a training app and I'd like to have the trainer be able to create quiz records in my quiz template table that would serve as the template for my quizzes table which is a child table of the quiz templates table. The idea being that the trainer can create "Quiz 1" by adding a record to the Quiz Templates table, then input questions and answers in text fields, then move on to create "Quiz 2" which would have different questions and answers. The problem I'm having is that I can't figure out how to populate multiple choice answers into the child record's answer fields. I've tried setting the Input Type of the fields to "From another field" but it doesn't work whether I point it at a textlist in the same table or parent table, point it at a textlist lookup field from the parent table, or directly at the multiple choice answer field in the parent table. Is there some trick to getting multiple choice text fields to populate from something other than typing the choices directly into the field (because then I'll be creating new fields answer fields forever...)? Some more specific info: Parent table: Quiz Templates Formula Text Field called "Question 1" which points at a Text input field where the trainer types the question Multiple Choice Text field called "Answer 1" which I want the trainer to be able to specify the choices for each quiz template record by typing in a text string with some delimiting character into a regular text field Child table: Quizzes Lookup field pointing to the Question 1 formula field in the parent table Multiple Choice Text field - should reflect the answers from the Answer 1 field in the parent table Any help/thoughts would be appreciated! AJ ------------------------------ Albert Campani Partner Richards, Higdon, Huguet & Campani, APLC Covington LA ------------------------------80Views0likes0CommentsRe: How to create a new record daily if date is within parameters
Thanks Mark! I was trying to add records so it would only allow the daily schedule as a trigger, but coping from the months to days table works perfectly. ------------------------------ Albert Campani Partner Richards, Higdon, Huguet & Campani, APLC Covington LA ------------------------------11Views0likes0CommentsHow to create a new record daily if date is within parameters
I have a Lease Terms table that has a child table called Months and the Months table has a child table called Days. The Months table records (one per month) are added simultaneously when a user checks a box in the Lease Terms table after filling in the necessary data. I have fields that determine the number of days in each month in the Months table. What I need to do is add a Day record every day (daily, not simultaneously) for leases that are currently in effect so that I can snapshot the base rent amount, leasable area, etc. on the specific date because these numbers change throughout the lease (for instance, if new mall tenants come aboard mid-month then the shared expenses (CAM) are divided among the new number of tenants starting on the day the new tenants take possession, so that CAM charges may be calculated at one rate from the beginning of the year, but a different rate as new tenants are added). However, scheduling an automation won't work because there are no options to filter or create Day records for only leases that are actually in effect, and an automation that relies upon changing data won't work because no user is changing data - just the date (Today()) changes in formulas. I feel like I'm missing something obvious but I've spent the better part of the day trying to figure it out and I've hit a wall. Any help would be very much appreciated :-) Thanks, AJ ------------------------------ Albert Campani Partner Richards, Higdon, Huguet & Campani, APLC Covington LA ------------------------------Re: Creating multiple child records based on the quantity of a field in the parent table
Just wanted to thank you for this Mark - it works perfectly! I was having a difficult time figuring out the best way to create month records for a lease term and this solved the problem. You rock! ------------------------------ Albert Campani ------------------------------109Views1like0CommentsRe: How to Identify Prior Record in Child Table for Use with Current Record
Thanks Mark! I'll give this a try. I was hoping to avoid user input for the prior term to lessen the risk that they choose the wrong term since it will ultimately populate rent rolls for each mall tenant (and cause major headaches at the end of the year if its wrong). If I want to lessen that risk, without getting too complicated, do you have any guidance as to what avenue might accomplish this, even if it takes outside help (so I know what yo ask for)? ------------------------------ Albert Campani ------------------------------24Views0likes2CommentsHow to Identify Prior Record in Child Table for Use with Current Record
Hello all, I'm trying to pull the previous term's rent amount to use in calculating the current term's rent. I have a parent table called Leases and a child table called Lease Terms. Lease Term records are categorized by the type of term (i.e., Primary Term, Primary Term Escalation, Option Term, Holdover). There may be multiples of each type (or none) except for the Primary Term so I also have a field for Term Number. When a new Term Record is created, I need the rent amount from the last term in order to calculate the increase for the new term. For example, if the last term was Option Term 2 and the annual rent was 100,000, I want to be able to pull that amount in to the record for Option Term 3 and use a formula to increase it, for instance by 3%, so to 103,000. I can create summary fields for the Leases table and then look up fields to bring them back down to the Lease Terms table, but different leases have different numbers of options so this approach limits functionality to the number of option summary fields and look up fields I create. Is it possible instead to somehow create a formula that looks at the current term description and subtracts 1 and then points to the fields in the relevant record (e.g., Option Term 2 is current so it would look up the record that is for Option Term 1) without having to create specific summary and lookup fields that filter for each option record? I'll also have to solve the problem of what happens if there are no prior terms of a certain type (e.g., if there is a primary term and and an option term but no escalation term in between) but I guess one step at a time... Thanks in advance for any help! AJ ------------------------------ Albert Campani ------------------------------47Views0likes4CommentsRe: Is it possible to have a copy parent record button also make changes to some fields?
You called it - I was plugging in a user token rather than an app token. Just fixed it and it works perfectly. Many thanks, I appreciate your time and your expertise. Have a great weekend! AJ ------------------------------ Albert Campani ------------------------------8Views0likes0Comments