Autonumber field cannot be used in the formula field?
Tech support told me that Autonumber field cannot be used in the formula field. However, my formula field was working fine with autonumber. Did they change the change the setting? My formula field is very simple. It shows "Last Name - autonumber." ex) Smith - null Of course, it shows "Last Name - null" when I save the record. But, when I edit the record, it surely showed "Last Name - autonumber." ex) Smith - 5930 I wonder why thousands of records were working fine, and it stopped working recently.
disable field on edit
Hello. Is there a way to disable a field on edit if it has data in it using script? Example: I have a service ticket for my field techs. One guy will add a record, then another will edit and add more data. I'm looking for a way to prevent the second guy from deleting data from the first guy. Each guy opens and edits the record multiple times so just can't disable on edit...only if data is there is what I need. Thanks
How to change message Invalid entries found??
Hello, Changing the message to my language Português Brasil? Invalid entries found. Please correct and submit again. TKS...
Calculation on a page
I need to calc this on a page Table: EntradasRomaneio Sum Field: Valor Grouped by Field: Contas_Banco I want to show the sum of Valor field grouped by Contas_Banco field in EntradasRomaneio Table
Place to write common business logic using multiple forms in Zoho Creator.
Hi, I am trying to write some business logic that involves multiple forms in Zoho Creator. I tried with functions but it does not allow to provide input /set a value from/to a form through a function. Sample code is mentioned below. int test.test() { input.Trainer_s_work_details.Number_Of_Account_Opened = Beneficiary[((Trainer == input. Trainer_s_work_details.Trainer && Bank_Account_Opening_Date >= input. Trainer_s_work_details .From_Date) && Bank_Account_Opening_Date <= input. Trainer_s_work_details
New to Creator
So we have an app, call it App A. Inside of App A we have 2 forms/tables. The first is more of a data form that our customers will fill out. The second is a form we will use in house to manage/track the project. The first field in the data form is *Project Name. Once the data from is submitted by our customer we would like to have this field *Project Name also appear as the first field in our back end form/table. What is the best way to do this? Would it make more sense to use a subform? Hope
Specified Duration in Success Message Issue
When adding a success message, I noted a new option to specify a duration. I assumed it was in seconds. But the value seems to be ignored. Is this a beta-feature? John M. Whitney
Creator Support No Answer
Is it just me or has anyone else had issues contacting Zoho Support via phone? it seems like every time i call it goes straight to a Voice Mail.
is it possible to change form design at run time?
I want add or remove button, or field at run time. meaning change the current form design. is it possible? thank you
Adding record into form with lookup field (by custom action function)
I created a function to load a new record with data from one row of a report. The form I'm trying to add a record into uses a lookup field (integer). The lookup field is mandatory. When I execute the function, I get an error: "Reference field unit_code not having the value 465,202" (the 465202 is the integer I'm trying to enter into this field, but the error is showing it with a comma, could this be the problem?) Must a lookup field always be entered by hand?
Zoho creator generated Emails are not longer received at Gmail and at Yahoo accounts
Hi, We have a form when upon new record additions an email is generated to recipients at Gmail and Yahoo. This used to work as of 3 months ago and has now stopped working. The intended recipients are complaining that they no longer get these zohocreated emails. After spending some time on phone with Zoho support and experimenting I narrowed this down to the fact that Gmail and Yahoo are not delivering these emails. An email box hosted on hostmonster however is receiving below. So it seems Gmail/Yahoo
replace date field datepicker with Calendar view?
I'm developing a job tracking application. There is a form, Jobs, that tracks each new customer job. Within that form, there is a subform for entering appointments with a client for estimates, jobs, etc. There can be more than one appointment for a job. The subform, events, has the basics for scheduling an event (event name, start datetime, end datetime, etc). I also have a calendar view of the events form. The event form is basically a schedule of all past and upcoming meetings with clients. When
Enforce Lowercase
I have an application set to only allow unique emails. However, I noticed that the same two emails can be registered as long as the upper/lowercase character are not the same. Is there a way to convert a string to all lowercase?
Can I show a related field in a form, without having a field for it?
Can I fetch and display the value of a field from a related form, without actually having to have a field to hold the data? This would be in On Edit, On Load example: fetchPerson[ID == input.person]; show fetchPerson.Email;
How Can I iterate through Radio Buttons
I have a Form with a number of Radio Buttons. I want to create a drop down list in a second Form based on the values of all the Radio Buttons (their names, I guess) whether or not they are selected. Bruce "Speedy G" Peaslee The World's Fastest Programmer
Pie Chart from a Formula Field?
How can a pie chart be created to show the percent of On Time Quotes vs Late Quotes? Form Fields Due Date Sent Date Formula Field On Time / Late if((Quote_Due_Date >= Quote_Sent_Date),"1","2") Thank you in advance
Formula
I need to use this formula but the formula field does not calculate this in the correct way ex. (Lunch_Number_3_5 *Serving_Amount_3_51) + (Lunch_Number_6_12 * Serving_Amount_6_121) (10*1.5)+(1*2) = 17 but this is not what Im getting. Im getting 32. Any help Thank you
Error Message with the "Delete Duplicate Records" Code
This is what I was told to put in to find duplicate entries in a a data base and delete. But when I do I get an error message. myList = list(); duplicateRecordIDList = list(); for each record in myForm [ID != 0] { if ( myList.contains (record.Email) ) { duplicateRecordIDList.add(record.ID); } else { myList.add(record.Email); } } delete from myForm [ID in duplicateRecordIDList ]; This is the error message Error at line number : 1 Improper Statement Error might be due to missing ';'
Fetch records
Hello, I need to set a report criteria based on a form from a different application, Is this possible? And also, how can I fetch a lookup field by its ID? Thanks.
Creator API Rest access is redirecting. No error codes are shown just showing Moved permanantly
I am calling rest api to add a record with authtoken, scope and NAME field in post request. But it is not showing any error codes but redirecting to zoho home page. I have free account. https://creator.zoho.com/api/skagrawal10/xml/copy-of-mtech-database/form/registration/record/add/
HTML View help
Hello all In my application I am trying to create a HTML view that allows me to capture details for my workers. The code is attached below: htmlpage Tankkarte_Details(ID) displayname = "Tankkarte Details" print = true pdf = true content <%{ Mitarbeiter = Personalien [ID == input.ID.toLong()];%> <strong> Mitarbeiter</strong>: <u><%=Mitarbeiter.Name%> <%=Mitarbeiter.Vorname%></u><%if (Mitarbeiter.ID == input.ID.toLong()) {%>
System is Responding Slowly
Hi, Do you know why the system is responding so slowly today? Please let me know. Thanks! -V
Photo upload not working
Hello. Anyone else having issues uploading photos into zoho? I've been using same app for months and today I can't seem to get photos uploaded....didn't make any changes to app or form... Checked my usage/quota and no issues there. Thanks
Issue in Script Builder Updating a Long-List
I made a function to clear a long-list field type from my database, but it was reporting this error: The only way I could get it to work was build the code in free-flow script mode: void DELETE_MEMBERSHIP() { for each row in parent_database { row.Schools = List:Int(); } } Clearly a bug! Cheers, John Whitney
Can I import data to CRM field?
I have a form in my application into which I am wanting to import data from a CSV. The form contains a CRM field. I have tried importing using the Lead_ID from CRM as the value for this field, however this does not work. I have tried importing using the Lead_Name from CRM as the value for this field, however this does not work either. Can anybody tell me what value can I use on import to link to the correct record in CRM? Cheers, Bianca.
Date not changing, multiple submits required, eternal please wait
We are having an issue that is now ongoing for about a week. The date box requires you to select a date at least 2 or 3 times before it actually changes. When you hit submit, it will not register the first time. We have waited to see if there is simply a lag, but nothing happens. When hitting submit again a "Please Wait" message begins circling and never stops. We have left it alone for a while and it still just keeps circling. If you go to reports the data was not entered.
Dynamic view criteria with access to other forms
Hello everybody. I'm trying to implement a sort of function that allows every single user to choose on which data sets he can work on. I found no problem with the FORMs by creating a table on which I save a sort of cookie for the user. The problem is with the VIEWs: I cant' make the view access that table and select the proper criteria selector (ie: the company). Is there a way to make the dynamic view criteria work? Thanks, Matteo
Import new data plus associated sub-form data
For importing data there is a checkbox - "Do you want to import subform data". It appears that this option does not allow for sub-form records to be imported against a single parent record, instead the import routine imports the sub-form record data against new parents. Can someone confirm this?? If so it is not worth having this subform import checkbox unless there is only one sub-record associated with each parent which really defeats the purpose of having subforms..?
On Load, On Success: Add Record
How do I add multiple records to FormB in one fell swoop? Form A has fields for StartDate and EndDate, and Duration (a calculated field) Let's say July 1, July 6, and 6 I want to insert 6 rows into FormB (one for July 1, July 2, July 3, July 4, July 5 and July 6) thanks
sms automation
I have a mobile number field (number field) in the delivery form I constructed. I went into settings, then automation and created a rule such that if the field in my form status of delivery is equal to "second delivery unsuccessful" an sms is sent(task). The task is below. sms input.Mobile_Number We tried to deliver your items twice and unfortunately you were not at home so please could you collect the items or phone us if you want to reschedule a delivery I added clickatell as a connection and used
Published App can Add, but can't Edit records. Why?
Hello, I published the below app forms to the public so that a customer can see the forms I created for him. He can add records with the Add Invoice link below, but he can't edit records in the Edit records link below. How can i change the form so that he can edit records? Add Invoice https://creator.zohopublic.com/iramalvarez1/published-qcr/form-perma/Invoicing/A6UKh9uAMga1eg9YCguh3xVN0pgySddyXpkF34UaUzPSsE2dOADC525pKBwBUAODBBCpfrFK0Ka4vNFn6j0DyjnJqabSOMwtxnf1 Edit Records https://creator.zohopublic.com/iramalvarez1/published-qcr/view-perma/All_Invoices/dHH2skxRqbbN6eMjyZDyp7RhbO82h8d9pG22jVeEqA1NxK7aObumW3DSQVP9GyByTqy6Q5q1muEKECMnRvv52UKTHsfFOABMseS7
Customer Portal
If I build a customer portal app in my account, can it be later moved to another account? PS: How many customers can sign-up per the old and new enterprise plans? Cheers, John Whitney
Can I access a Pivot Table via a Custom Action?
I know how to write a function, so I can access a form or view via a custom action. What is the syntax for opening a pivot table?
Formula field Date Calculation shows time too
In a formula field, I am trying to subtract days from a date field. The formula field displays the correct date, but also includes the time. Is there a simple way to strip the Time and display only the date? I know it can be done in a tedious way, by creating more formula fields, convert to string, then getPrefix, then convert back into a date, etc, but i was hoping there was a way to accomplish this all within the one Formula field. (Registration_Expiry.subDay(150)) the Original date field contains
Getting an unknown error when trying to add a user to the portal.
I am trying to add a user to the portal. I get this error message "An error has occurred. Please contact support@zohocreator.com for assistance." I have sent an email to support, but I am curious if anybody else has seen this message and knows what it means. I have attached a screen shot. I am stuck until support gets back to me, so if anybody knows what it means let me know.
Lookup an email address in another form based on dropdown selection.
I have 2 forms. Form 1 is a Sales_Rep form with 3 fields: Name, Email, and a checkbox for current employee or not. Form 2 is a Job form with many fields. One of these fields is a dropdown lookup of Sales_Rep.Name. In the "Form Actions, On Success" deluge script of Form 2, id like to send an email to the Sales_Rep.Email of the selected Name. Im unsure of how to declare this variable.
how do i open a specific stateless form in edit
I have a form 'A' which when submitted saves the data in that forms 'A' report. Now i have a stateless form 'B' with some selected fields from form 'A' and when submitted saves the data in Form 'A' report. But when i click on edit in the report to the data of form 'B'. i am not able to open that stateless form 'B' in edit mode.instead it opens Form 'A'. So, i just want to open that stateless Form 'B' in Edit mode of Report A.
Coding help
I'm trying to learn the basics of writing this code. Can you recommend a book or website for a beginner? What's the name of the code? Where can I do some research? Thanks, Steve
Language of public forms
Hi! Is any way to control user language in Public form ? User of public form always the same, so is any way to set/change user language?
Creating a user submitted query
I have been looking for some time for a relational database solution for a simple membership app and I'm hoping this might work. I used to be a database admin years ago but was not a programmer. I did a lot of SQL and some simple scripting but don't have a lot of coding experience. I would like to create a relational database with I think 3 simple tables, a member table, a registration table, and a merits table. The master table would be the member table and contain all pertinent data about
Next Page