Trying to be to clever
I have created a ToDo form and have two other forms, let's call them A and B. Todo's can be either general or specific to either A or B. So what I did was create a subform, first in the A form and then another in the B form. Went to the Todo view added a look field to the A form and another lookup field to B form. No problems with the on the A side but there's something wrong with the B form. On the B form when I click "Update" i get a spinning icon and "please wait" but this never goes away. I get
Help with creating a quote form...(new user)
3/27/17 - Been using Zoho for just over a month and need help with creating a Quote Form: On the Quote form I have 2 lookup fields that both are radio buttons : Field 1: Field 2: When any of the first 3 options in Field 1 are selected and any of the 4 options in Field 2 are selected, I need it to update the Monthly Rate Field on the Quote Form from information on the Storage Rates Form below.
Help! Help!! Help!!! "Unable to send message;Reason:554 5.1.8 Sender Address Blocked"
Hi Everyone / Moderator/ To whom this may concern, My Name is George; This is the 5th message i am sending to request assist from the moderator on my account. I noticed that i have been blocked from sending messages without sending any unwanted or promotional emails whatsoever. Please, Can you help me unblock my email, so i can reach my clients as this is my company email?? Email: info@bbmilleniumllc.com I am counting on your guy to help me resolve this effectively and swiftly, Thanks for your anticipation.
Retrieve data value from different tables all in a new table
Hi, I would like to know if there is a way to retrieve data values from different tables into a single validation page. For example if we have, 3 steps process Step 1: Enter customer data Customer Table CustomerID:001 FirstName: John LastName: Smith with Submit button - data insert in Customer table Step 2: Enter Appointment Appointment Table AppointID:001 CustomerID:001 AppointmentDate: 22/3/2017 AppointmentTime: 10:00 Step 3: Validate Here what I would like is to retrieve all the information from
Lists cannot be compared?
Hi Zoho, I have the following script: ListA = {"A","B","C"}; ListB = {"B","A","C"}; if ListA != ListB {%>Lists Not Equal<%} When trying to save, I get the following error: Error at line number : 7 at column 54 In Criteria left expression is of type STRINGLIST and right expression is of type STRINGLIST and the operator != is not valid This also happen when marking "equal" using double equal sign (==) , but single equal sign (=) is ok. Please fix thanks Ravid
Remove time from date-time formula result; not using .toString()
Dear Friends, I have date-time formula in a form to calculate certain date. Then, I have report (list type) based on this form, where I want to sort all records according to this formula field. The problem is: - To sort by formula field, I have to add this field into the report, and then only I can drag it into Sorting order - Consequently, this field becomes visible and occupy too much space in the report. The problem is that it shows also time stamp, which is meaningless for me, like: 28/03/17
New customers get better pricing than old customers?
We signed up for Creator in November 2016 with 3 users on Enterprise. We have used our 30k limit of records and have had to purchase more. Yet apparently the pricing for NEW Enteprise customers has UNLIMITED records. The support request I have just received, with its ridiculous, sunny, cheerful and inane language telling me blithely I have to spend more money than if I had signed up last week, is as follows: --- Greetings from Zoho Creator team ! The Pricing which you have referred to is the Latest
7 day reminder automated email
Hi Guys I would like to setup up an automated email reminder. The condition would be, if a record had not been updated after 7 days of creation it would send out the remainder email. Any help, would be appreciated greatly. Thanks Chris
dynamically add fields?
is there a way to dynamically add fields to a stateless form? e.g. user selects 3 items from a list (a, b, c from the entire alphabet). then generate two fields per entry, such as: a_method: a_result: b_method: b_result: c_method: c_result: obviously this could be done with show/hide, but for higher numbers of items, using iterations would be easier if it's possible. it would also be helpful to be able to then insert these into another form using iterations.
importing data from zohocrm
Hi i have hit this barrier again. We would like to move some data from zoho crm to creator. We have a field that links this data to a contact and would like to keep that intact on importation. Does anybody know how to do this as all we get is a number
Comma
It's almost a deal breaker for some users that the currency fields do not have commas. When I tell my users I can't do that I look like an idiot. Do I really have to roll my own validation and formatting with text fields? Was it a $100000000 dollar deal or was it a $10000000 deal? There are 90 million good reasons right there for commas. Please add commas. Please. tx, tt
Customer Portal User Groups
I have been told by a customer that in the next couple months they wish to move away from generic accounts per dept into user based accounts. This means that every user will have an account so I'm looking at at least 1500+ users, at first i figured i could use the customer portal of the application but because this doesn't support group creation like the normal global user setup it'll make user management a nightmare. the second option would be to have each user signup for a free account but because
Send Mail with selected Records as attachment
Hi, Is this possible in Creator that I can send a XLS file as a attachment for selected Records only using Sendmail Function ? For instance If I select 10 records in the View and click on Function so it send out those 10 records' details as a XLS format to respective email.. Thanks Arfater
Can't delete function
Hi Zoho, I have several old functions I'd like to delete. When I click "x" I get the following message: Function cannot be deleted. This function is referred in the following places. Please remove the reference,then try deleting the function. I can't understand where the functioned are used (and don't think they are used, anywhere) please fix Thanks Ravid
"With Action" to all the forms at once?
Hi Zoho, How can I view the "With Action" of all of my forms as once? I'd like to replace a certain fetch command with a function, anywhere on the application. Thank you Ravid
View single public record via URL in record-summary view
SOLVED - See below. I would like to view an individual record summary (from a custom summary view) from a published database by passing the record ID via URL. I see from the Zoho documentation how to print an individual record: https://creator.zohopublic.com/<adminUserName>/<appName>/record-print/<viewLinkName>/<RecordID>/<encryptedKey> This creates a print dialog box for the single record in summary view. If I hit the 'Escape' key, I exit the print dialog and simply view the record EXACTLY as I
Accents can't be used for true/false values in Reports
This is pretty self-explanatory : Is there any way we can have this working? This is especially a problem for our french-speaking clients, because in French, past tense verbs used as adjectives often end in "é" (ex: "Ajouté" means Added) which is counted as a special character, when it shouldn't.
Users and Perimissions
Is it possible to restrict users so that they can see and edit only records that they have entered into the database? I am developing a subscription application for orthodontic offices. Of course, I don't want the users from different offices to see, and edit the data from other offices. I have created a profile named "client" and given them permissions to Access, Create, View, Edit and Search. I have also shared these forms with the "client" profile. When I use the client's log in, everything
How to pass parameters thru HTML popup form
I am using "#Form:<Form>?zc_LoadIn=dialog" for an HTML link popup form and I would like to pass values to this popup form so that some fields autopopulate. How do i do this?
Criteria for if "date is equal to or after today"
I am trying to fetch records where the date is after today. What is the criteria for dates that are equal to and after today? I tried date After today; date After zoho.currentdate; date >= today; date >= zoho.currentdate; But none of these work
Conditional formatting for duplicate field in a specific column
Hello, I need to highlight the values in a specific column when that value appears more than once. How can I do it?
Help! Help!! Help!!! "Unable to send message;Reason:554 5.1.8 Sender Address Blocked"
Hi Everyone / Moderator/ To whom this may concern, My Name is George; This is the fourth message i am sending to request assist from the moderator on my account. I noticed that i have been blocked from sending messages without sending any unwanted or promotional emails whatsoever. Please, Can you help me unblock my email, so i can reach my clients as this is my company email?? Email: info@bbmilleniumllc.com I am counting on your guy to help me resolve this effectively and swiftly, Thanks for your
Best Excel import and form setup method to reduce work manually re-creating lookups
Hi I have just starting using Creator and learning its features. I have a single Excel sheet with many columns, that I have imported into Creator. In one of the early attempts, one of the columns was imported as "Drop Down". This is close to what I want to do (forcing users to use correct and full customer names - rather than the free for all data entry that was happening in Excel). What I actually want to do, is to end up having that 'column' of data split out as a separate form - to be used as
Is it possible?
If we have a table containing tests which are grouped. Can the groups of tests be "pulled" into a new table/report for "Test Results" as a group. For example, the "Test Steps" has a field called "Test Template" which is used to group multiple rows which are the test steps for a particular device. I want to be able to select say "Test Template 1", "Test Template 2", etc and have a new table created. There will be multiples of each template i.e. multiple devices in the new table. For example, "Test
error on .contains() when value is null
Hi Zoho I have the following script : htmlpage test_page(Var01) displayname = "test page" content <%{ if ((input.Var01.contains("Yearly"))) { test=1;} %> <%=test%> <%}%> When Var01 is null, the .contains function return an error and will not load the page: Error details: Error in executing test_page view script. Error. Error in executing IF rule : Error in executing If condition. Error evaluating Boolean expression : Error evaluating BOOLEAN expression : The value of variable Var01 is null. Please
brindha
Im new to zoho creator.i want to create a quiz application .anyone guide me.
Open A Separate Form from a Separate Report
Hello, I have two forms for this example named Form_A and Form_B - the users input data into Form_A using 'Insert Into' I pass some of the inputted fields into Form_B including the 'Auto_Number' field into a number field in Form_B. I would like to in report view of 'Form_B' add a Custom Action against each record in Form_B that when clicked opens the Form_A (in edit mode) for the matching record For sample Form_A ID field = ID_One (autonumber) is inserted into Form_B number field ID_One On clicking
Zoho creator deletes code snippets /doesn't save code
Hi, The application is not saving the script I write "Edit -> On Load". I had some code entered in the above mentioned section, when looking at it earlier I noticed that half if the code I had written out is missing. Luckily I had saved it somewhere else, however when I paste the code and tell it to save the script it doesn't save it. It give the notification "saving.." then "saved", but if I switch to another view and back, the code snippet disappears again. This is the second time that this has
Copy lookup field text into single line field.
Im not really a noob but I defiantly feel like one today, Im pretty sure I've done this before but what I'm trying to do it populate a text field from the chosen result of a lookup field. This is the current code, Ive tried many but this is what I can remember. input.Nextjob = input.Which_Site_will_you_Attend_next; NextJob - Single Line Which_Site_will_you_Attend_next - Lookup Field I want to copy the result as shows in the lookup field which is primarily the client loaded from that form but
Understanding User Management and Counts in my Zoho Creator Account
1. Are external users with access only through the customer portal counted and billed for the same as shared users ? 2. I have 36 active users in my User Setup Page whose usernames do not always match that listed in the application's shared list despite having the same email addresses. Why? 3. Customer Portal users show up in the application shared list but not in the Zoho Account User Setup Page. Why? Zoho Account User Setup Page: "johnsmith" (App shared list below shows same username with additional
ZC Plugin for Word escaped characters
We've noticed that when importing Zoho information into Word using the ZC Plugin for Word, special characters in text fields are rendered using slash-escaped characters. Sometimes this causes information to go missing entirely. Would it be possible to modify the plugin so that it is able to take the text field content from ZC and convert it into a Word-compatible format so that it appears in the same manner as it does in Zoho?
Ability to view uploaded PDF files
Zoho Creator has lovely field types to design forms to allow users to upload a PDF, but that's about it. What we really need is the ability to be able to view these files.
creator drop down issue in ipad and iphone
hello, i m new to zoho. i couldnt see a dropdown list in my ipad and iphone when i could see it as a drop down in laptop. if i customise many in listing it shows as drop down but 3-5 options in my listing all 5 are shown which makes my form look bigger and complex.pls help me out
Pivot Table based on Form input
Hi Support, I want generate pivot table based on user input in a form. Example below. Form1 (Has below Field): Country: Section: No of sales: Form2: Country: No of Sales: When user select the fields in Form2 and click on submit, a pivot chart needs to show based on data from Form1. Your help is appreciated. Thank you.
How to add a new field to an existing form
Let's say that I have a form with a dozen fields and thousands of records. How can I add a new field to this form and import the new data into it? I have the data in an Excel file. The only way I can see to do this is to import the XLS and just make a whole new form, but this will break all the relations I've made with the original form. This seems like a simple and fundamental thing to do, but I'm not seeing it. Thanks.
Added_User in formula field doesn't work?
When I try to use Added_User or Added_User.toString() in a formula field, the end result is always blank. I can use ID ... how do I get to use Added_User? Thanks in advance for any leads.
Calculating the total amount of a subform is not working correctly
Hi I was following along the tutorials on zoho site. Link : https://www.zoho.com/creator/help/tutorials/advanced-app-building.html Section: SubForm Actions --> 3rd part. When I'm testing the calculation on my app, the first product that i select within the subform and I am changing the quantity the total amount is working fine, but when I add a new product and I put the quantity at 5 The total amount doesn't make any sense. I don't know if this is a bug or maybe I have did something wrong on my code
Comment form
Hi Is there anyway to add a comment form to embed in my website similar to the one found in blogs which gets updated automatically when a viewer comments?
How can I display the records from a form in HTML page by Month or Year?
I have an application that processes salary of employees and I need to create an HTML page to shows the records with details monthly of the processing. In there page must conste the details of the organization and other information, but the data must be showed monthly selecting the month in some field of type "select". I've tried to embed the Salaries's Processing report, but it don't work like I want, because, when I print the page the other informations of HTML page don't appear. Please, help me.
Loockup
How would you use Loockup when you select and search for data from another form? so i need the code
Next Page