RajeevShukla
Qrew Member
Joined 6 years ago
User Profile
User Widgets
Contributions
Condition on Lov
Hi Team, Please suggest possible ways to achieve below Case - I have two Text - Multiple Choice field 1. Status with LOV (Yes/No) 2. Method with List of values (Sample 1/Sample 2/ Sample 3/ Sample 4 /Sample 5/ Sample 6). Condition : If Status = No than List of values of Method Fields should appear in form will be (Sample 1/ Sample 4 /Sample 5) . Let me know any ideas on the same . ------------------------------ Rajeev Shukla ------------------------------Primary Key creation
Hi Team , Can we create Composite Key on Quick base Tables . Like I have two column Customer Name & Customer Address in Customer Table . I want to use unique Identifier = Customer Name +Customer Address . Is it possible to achieve this functionality . ------------------------------ Rajeev Shukla ------------------------------Re: Looking for best practice to achieve below functionality
Thanks Mark , This looks promising , But we can not use [Record ID#] field as we are going to reset this sequence in end of every year . Idealy, we want to update one field ProjectID whenever a record is added in that Table . #1 Format Will be (Field1-CCYY-Sequence of 5 Digit) CC- Country Code YY- Year(Last two digit of year i.e 2020 it will 20) Field1 - Another column in the same Table. For Example Project ID : 2536-US20-00025 (Complete Format we need ). We will reset the sequence at end every year. Please provide you suggestion on the same Thanks, ------------------------------ Rajeev Shukla ------------------------------8Views0likes1CommentImport in Table Question
Can we import data into two tables simultaneously from one csv or excel file. For example suppose we have one row in excel file which having 10 coulmn and I want to import five column into Table-A and another five column into Table-B. Is it possible if Yes then How we can do that?? ------------------------------ Rajeev Shukla ------------------------------