Copying data between two forms
Hi Sorry if this seems like a simple question! Currently I have an 'Application Form' that is completed by a customer. I want to be able to automatically draw information from this form on Zoho Creator to another form in Zoho Creator. For example: The contents FirstName field in 'Application Form' be copied to FirstName in another form. I think I need to use a stateless form for this but really don't know where to start. I've read the support docs on stateless forms but would appreciate any advice.
Universal search, instead of one search per table
It could be very usefull to have a "universal search" in Creator, instead to search table by table. For example, the user search a person Mr "Little", and he wants to know all the rows of all the tables where "Litlle" appears. It could be very helpfull for basic users. Thanks in advance. Best regards Jérôme
Having Problems with IPAD App when trying to load my form (Zoho Creator)
When I try and access my form through the Ipad App it kicks me out to the ipad main screen and will not let me access my form. It lets me get into my Zoho Creator portal and lets me get my form reports, but not the form itself. Please Help if you can! I am very new to this and am not sure I even Published it right!
Delete row from another form
Hi, I have a delete_form which have a field called -- TV Station . The TV Station field is the look up field from another form Station_List . Now when user select any station name from drop down list of Delete_form then I want to delete this station from another form LPTV_form , where TV station is the lookup field of the Station_List form also. I have tried the below code but not working might be because of two field are look up to another field if (input.TV_Station != null) { delete from
Allow an admin support staff to enter and edit records?
Some of our sales reps use a shared support staff member to enter and edit records in addition to the individual sales rep. What would be a useful form structure for this? Currently if a sales rep enters a record the system value Added User can be entered as a criteria in a Report to filter all appropriate records for editing purposes. The criteria would be Added_User == zoho.loginuser This is made more complicated if some records are being entered or edited by a shared support staff member.
look up field with pivot function in zoho
Hello I need some experts for help me to make the below function workable Sourcing view Form Pivot Here you can see all the fields are look up fields from sourcing view,function I would like to set up is same as exel pivot table, for example while user select specific data in Region, country fields only pop up data under this selected region. I’v tried many times with different solutions, still doesn’t work. Please help Many thanks Priscilla
is it possible to insert a record into a subform of one form, from separate form?
is it possible to insert a record into a subform of one form, from separate form? example: insert record into subform of form2, from a field in form 1
can you link to a file upload field in a stateless form
I have created a stateless form to show data from multiple forms. When I select a lookup in the stateless form I want it to give me a link to a file that was uploaded in the corresponding form.
4x4 Row in form
Hey people, I'm using the trial version of Creator right now and really like it. I am planning on getting the full version but am caught up on one part. I can't seem to figure out how to insert a 4x4 row into my form. I can only seem to make single fields, but can't place them next to each other or underneath each other in a 4x4 fashion. If anyone knows how to do this I would greatly appreciate some advise. Below I've attached some screen shots to show what I'm trying to do what where I'm getting
auto populate lookup field based on previous field entry
Hi, I have form which has five field like below TV Station Form : TV Station Not -01 -- -- (lookup field from Network form) Not -02 -- -- (lookup field from Network form) Not -03 - -- (lookup field from Network form) Not -04 ---- (lookup field from Network form) Screenshot of TV Station Form view ; What I am trying to do is to fetch all respective values from the fields --Not-01, Not-02, N ot-03, N ot-04 to a picklist Network of below form when user select any station name. Say User Select TV
zoho reports is not updating
The following is the code I have used to update the data from Zoho Creator to Zoho reports, unfortunately it is not updating the records. And no error is generated at the creator screen. I just want to update one record based on date criteria. rowInfo = map(); rowInfo.put("Date", input.Date_field); rowInfo.put("NewDaily", input.New_Cars_Daily_Sales); rowInfo.put("UsedDaily", input.Used_Cars_Daily_Sales); rowInfo.put("WholesaleDaily", input.Wholesale_Daily_Sales); criteria = " \"Date\" =' " + input.Date_field
Using "clear" on a picklist in s subform results in invalidTaskInSubForm
According to the doc https://www.zoho.com/creator/help/fields/add-to-picklist-dynamically.html I should be able to use "clear" to clear the current values in a subform picklist on the On User Input. but it does not work. list = Member_Rep_Shift [ID == Appointment_Details.Shift_Picked]; clear Appointment_Details.Time_Picked; Appointment_Details.Time_Picked:ui.append(list.Available_Hours.getall());
I have a simple formula i added on delete row in my subform. but its not updating the main form until i delete the second row
input.Tax = 0.0; input.Amount = 0.00; x = 0.0; for each row in Activity { if (!row.Bid_Work) { x = (x + row.Amount); } } y = 0.0; for each row in Activity { if (!row.Bid_Work) { y = (y + row.Tax); } } input.Tax = y; input.Material = x; row.Total = (row.Tax + row.Amount);
Lookup Fields can't be set as "Read Only"
Hi - I am working with Users & Permissions and I have set some Look Up fields as "Read Only" for selected users. Unfortunately, these settings don't seem to work correctly. While I can NOT change any other fields that is set up as "Read only", I can still modify Lookup Fields as well as file upload fields. Any solutions on this? Thanks,
Previous Import Not Shown on Report App
I'm evaluating the Basic Version. I had done an Import of 721 records, and everything came through, except there were some records that had errors, which I fixed. When I tried to re-import the corrected spreadsheet it wouldn't let me because it said I had too many records. I called support and he told me I could only have 1000 records for free version. He said if I wanted to re-import that I would have to go to the Report app, select all of the records, then delete them. Then, I could re-import
Issues dynamically populating a SubForm at the OnAdd.OnLoad event
I want to know how to populate a subform at the OnAdd.OnLoad event of a form. I already know the ID of the fields I want to populate it with, as they already exist in the subform and I simply want to replicate them. I am having issues with the dynamic creation of the rows in my SubForm. For context, I am building a feature that allows the user to create multiple versions of the same record, with minor changes, and so I built a custom action that redirects the user to the onAdd of the form, with a
Stateless Forms and Pictures in Subforms
These do not seem to work on mobile version. Is it in the pipeline?
Can i create a form dynamically using zoho creator ?
Hi, I have a multi check box selection, I want to create a separate text box for each and every check box selected. Is it possible in zoho creator. Please help!
Fetching data from forms into pages
Apologies if this has been asked many times, but - I have a form ('Form_A') with two lookup fields ('Image_Title' and 'Image_Name'). I want to create a Page in which the data that has been looked up is fetched from the Form and displayed on the Page. I have already read all of the various help pages but I'm not particularly code-savvy and, despite my best efforts, I keep coming up against error messages such as 'null', 'the input 'Image_Title' is not defined', 'type required bool; type found string'.
How to Add Multiple Records
How add Multiple records to form using url post . Because I need to transfer data to another form in another application .
SMS function - International numbers
Hi, I'm from South Africa and our international code on contact numbers is (+27 or 0027). If, I want to use the Zoho default sms function, does my number field have to have the contact number in the international format or any format would do? For example, here in South Africa, mobile numbers start with a "zero". If the international format is required how can I configure my field or script so that what ever "number" is entered into my contact number field has the "+27" international code for South
Sync between Creator & Reports
We use Creator extensively. W e now need to reduce our record count which means deleting older records before a certain date. We need to keep these records somewhere though, so we are planning to export them to Reports. The power of Reports in visualizing/manipulating data looks fantastic, so I am wondering whether I could use Reports to sync with Creator ( as I've seen is possible) so that we have all sales data, both older and recent, in Reports to manipulate/ visualize. However, I still need to
Apostrophe in URL has stopped working
Hi I've had an application for years that loads a variable through the URL with an apostrophe using %27 ie - http://[URL]/Add_Performances?Venue=King%27s%20Theatre%20Glasgow but it has now stopped working. All non-apostrophe variables are fine. Any ideas? Robert
Can someone help with this code?
I'm trying to setup a function to email certain people based on the zip code entered into a form and I'm getting an error with the following code. It's telling me there's an error at line number 1, which is the whole zip code or statements. if ( (input.Zip_Code == "92807") || (input.Zip_Code == "92808") || (input.Zip_Code == "92823") || (input.Zip_Code == "92870") || (input.Zip_Code == "92886") || (input.Zip_Code == "92887") ) { sendmail [ from:zoho.adminuserid to:"jason@lean-labs.com"
Link to form in emails to external users
Hi, I am developing an application which under certain circumstances will send emails to external users with a link to a form for them to enter/update data. there are 2 types of links - link to a form to allow external users to create a new record - the link will contain parameters which will prepopulate certain fields on the form. - link to a stateless form to allow external users to update a record - the link will contain parameters which will prepopulate certain fields on the form. When the submit
Formatting Number Fields
Is there any way to format a stnd number field as x,xxx?
Exporting a Creator File to CRM
How do I export a Creator file into CRM? Is there a YouTube video? Thanks, GPL
"Merging" 2 Imported Fields Into 1 Displayed Field
Is there a way I can Import 2 fields (1st, and last name) from an Input app in Creator into a field that displays as 1 field on the Report app in Creator? Thanks, GPL
Establishing a LookUp Field
How do I establish a LookUp field for a field that's already established?
Merging a 2nd Spreadsheet Into Master Creator file
I have 2 files that have mostly dups, but a few unique records, that I want to import into my Master Creator file. Is this possible, or do I have to simply take those unique records and copy them to new records into the Master 1 by 1?
How can I determine the number of records I am using at this time in all my applications?
How can I determine the number of records I am using at this time in all my applications?
Ipad not displaying forms
My applications work perfectly with a pc, iphone or ipod touch, but not the ipad. The window using applications displays, but whenever I try to open a form, it starts to display the form, but closes and ends up in the ipad window showing the standard ipad start window with all the apple apps displayed. Update: I found that it is Ios 8.2 that is causing the problem. I bought a new ipad mini just today, and when I tested it with Ios 8.1, it worked fine, but when I upgraded to 8.2, the same thing happened.
Commas in decimal field causes problems
I have an application for our contractors time and expenses. The expenses are entered as line items in a subform. This application adjusts the total each time the date, amount, quantity, or currency type is selected or changed. When users enter commas in the decimal field for the Amount, it causes an error that stops the script from continuing so it if there was already a total calculated, and someone changes the Amount, and adds a comma, it won't calculate the total, which is fine, but if there
How do I calculate (today) - (date)?
I'm trying to create a formula which tells me how long I have items on-hand. I think I've gotten close, but I can't get it to work. When I use ( zoho.currentdate - input.MFR_DELIVERED) I get a long version of time. I can't seem to figure out the rest to get the short for of the time. For example, instead of just "9" (for days on hand), I get 777600000. And, I can get this " /(1000*60*60*24)" to work in excel, I just don't know Zoho language to make it work here.
Publish/transfer an app to another client's app
Can you create an app in your own account and then publish/transfer directly to a client's app? Don't see instructions on how to do it. Joe
How can I set report critera depending on information related to the current user?
Hi, I couldn't set report criteria depending on information related to the current user. For instance, if I want to show record from a specific table, I have another table that relates each email with a country, and I want to show only the records that the "country" field is filled with the same country as the current user. something like this: "country == User (email==zoho.loginuser).country" I also tried with user defined functions but reports doesn’t like them cheers! Javier
Add New Entry link not showing in lookup field
The link does not show for users that are not administrators when the lookup form (the form that supply the records to be looked up) are in another application. Is there a workaround for that? Thanks
Hyperlink text wont import into creator?
Is there a way to import the hyperlinked text in my csv file into creator? when I import it it strips out the hyperlink and just leaves the text.
Add notes field does not accept <style> tags
Dear All, In an Add note field if I add the <style> tag like the image and click the Insert then if I go again to the add note to edit something then the box is empty...I tried to click all the buttons (insert-edit HTML etc.) but nothing. Why this happens? If I want to have a style for example in a Add Note field (with <style> tags) then everytime I must delete the add note field and add a new one with the new style?
How to Add Custom Styles Zoho
Hi, I am trying to replicate an existing form I am using, I need to be able to apply custom css to the form that I am currently using and also use a custom image for the submit button. How do I do this? I wasnt able to find any documentation and also when applying my styles in the stylesheet they don't show up Thanks
Next Page